Threads Replies Last Post 14 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14   user form alignment I just created my first user form. At least it is working. How do I set a default "--- Please Select ---" as the default so a user will be directed to click the down arrow and make a selection. Also, how do I align where the user form displays on the page? Thank you. ... 3 4/27/2006 12:37:04 PM FAQ - Frequently Asked Questions - vba - please read before posting - unofficial April posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted weekly.- more or less Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non-... 3 4/23/2006 11:32:25 PM Word Locked Form Field Focus In a locked Word document with several form fields, is there a simple way to make whichever form field the user tabs into center on the screen? Sometimes after tabbing in my form the cursor goes to the correct field, but the only way to see it on the screen is to scroll the pages up or down. Thanks, Chris ... 3 4/20/2006 3:38:28 PM Save entries made by users over different Word session Hi everybody! I would like to create a form that allow the user to pick words from a list (combo, list box, or else). Those words will then be used for a search in the document. But I want the user to be able to modify/add/delete words to the list and save it when Word closes so that the list grows over time. I did not start writting code. I'am just trying to think of the best strateg... 7 4/20/2006 11:36:26 AM Jumping/Skipping Form... Howdy again, I have a locked Word document with several form fields that have macros that calculate on Exit. The macros are fine (thanks to help from many of you!); however, each time I tab out of a field to go to the next field, the entire screen 'jumps' first (obviously as the macro calculates); then, although the next subsequent field to be filled is selected, it is all the way down at... 5 4/19/2006 10:54:26 PM Form tabbing issue - toolbox I have a custom form in Word 2003. When tabbing through the fields after one combo it then tabs to the design toolbox and displays it then goes to the next field. Is there a way to prevent this? ... 4 4/19/2006 10:11:21 PM Tricky: Word Table Conditional Formatting Hi there, I've got a stumper..... First, I have a Word document with several form fields. Some of these fields calculate into subsequent bookmarks. The problem: At the end of the Word document, I have a simple "Overall Score" table that is 2x4, laid out as such: Ranking Rating Fair 0-.99 Good 1-1.99 Great 2-2.99 Excellent 3-4.00 The rati... 9 4/18/2006 10:35:51 PM only print checked boxes and its command Denise Bonjour à tous, J'ai un petit problème avec un formulaire Word. J'ai fait un très long formulaire qui offre aux utilisateurs de nombreux choix de commentaires. Maintenant, j'essaie de l'imprimer en n'affichant que les éléments cochés. À chaque fois j'obtiens une feuille blanche avec des X parsemés sur 7 pages!!!! Pas très utile. Comment réunir en une liste les éléments coché... 2 4/17/2006 8:34:20 PM only print checked boxes and its command Denise Bonjour à tous, J'ai un petit problème avec un formulaire Word. J'ai fait un très long formulaire qui offre aux utilisateurs de nombreux choix de commentaires. Maintenant, j'essaie de l'imprimer en n'affichant que les éléments cochés. À chaque fois j'obtiens une feuille blanche avec des X parsemés sur 7 pages!!!! Pas très utile. Comment réunir en une liste les éléments coché... 1 4/17/2006 7:15:23 PM for sale: internetDotComs.com domain for sale: internetdotcoms.com http://www.afternic.com/name.php?id=11866440 ... 1 4/16/2006 1:45:35 PM extracting data from forms Hi, hope someone can help. We created a form which we sent to our students to complete and return. When the forms come back, they are as .doc forms. However if we want to extract the data, we have to set the options (Options > Save > extract data from form) on every occasion- sure this can't be right. I guess we have done something wrong. Can anyone help please? Thanks ... 5 4/13/2006 2:56:01 PM Goto Option_Button; Calculations; Auto-update; Even Colors! I've got what is probably not a terribly hard bit here, but I'm still very new to VBA in Word and I'm stumped. Here's what I would like to be able to do: I have a Word 2000 form that has several rows of rating criteria; the ratings are from 1-4. Managers have eight (8) criteria to be rated, while non-managers have five (5). I have put in a userform with two option buttons and the questi... 2 4/11/2006 8:26:01 AM Control value I am trying to put the value of my userform textboxes into an array. Control object doesn't have the value property, for me. I get to the ctrl that has the value I need, but it always gives me the default value for the control, not the current value of the control (i.e., "DocArray(M,2)=ctl"). How can I capture the value of the control I've looped to? Sub getCopies() Dim propNumVal As... 4 4/10/2006 9:43:18 AM UserForm to retain value for copy and paste Hi... I have a userform that I created to describe who is running test. The form has a text field for tester, type of test, etc. How can I retain the form values(tester,type of test, etc.), making them availabe for a copy and paste macro. I want the values to be retained until someone executes the userform and enters new values. Thanks ... 2 4/9/2006 5:54:47 PM Auto name multiple bookmarks Hi All, I have a user that is under the gun to add tab order to a Word .dot with ~ 500 form fields, many of which are 'duplicates' of each other. For example, the form looks something like this: | Emp1 | Job1 | Job2 | Job3 | | Day1 | Hours | Hours | Hours | | Day2 | Hours | Hours | Hours | etc... To get the lines beyond Day1 into the form, the user copied/pasted the first ... 5 4/6/2006 9:05:32 PM - How to show AddShape object over Image control? I am having a problem displaying a shape object over/above an image control. What I am trying to do is pretty simple - draw a circle on Image_click over the clicked area (see the code below) The problem is that the newly added shape object appears behind the image (and cannot be seen) even though its ZOrder property is set to msoBringToFront. Ohh, and by the way could someone sugges... 2 4/3/2006 4:00:34 PM Calc on Exit...from Slider bar? I have a slider bar (Scrollbar1) that chooses a value between 1 and 4. That value then populates my userform at bookmark "Row1Total" via this VBA: Private Sub Scrollbar1_Change() ActiveDocument.FormFields("Row1Total").Result = ScrollBar1.Value End Sub There are three slider bars altogether, and as each one is assigned a value, I would like the "total' at the bottom to update autom... 2 4/3/2006 3:02:58 PM Word 2003 FormFields Hello, Does anyone knows how to erase the value of a FormField in Word with Office 2003? When I am using the code as membered (sending an empty string) below I get an error and the FormField is still having it's value. '= BEGIN CODE Public Function WriteDocFds(iBookMrkNm, iVal) 'Office2003 On Error GoTo errHandler Set ffield = ActiveDocument.FormFields(iBookMrkNm).TextInput... 5 4/1/2006 9:15:45 PM Expressions? Ooops, may have mis-posted this in the VBA group..... Two VERY beginner questions: When I see the { } parens in the examples of what to use in word form field expressions, do they need to be in the expression field as well? Also, what expressions can I use in form field calculations? For instance, in Excel I would have this formula in a cell: =IF(A1=0,SUM(A2/5),SUM((A1+A2)/8))) ... 2 3/30/2006 7:58:29 PM Userform on top of document In Word 2000 I have problem with keeping a userform on top of a specific document. I know this has been discussed before, but I cannot find the threads. BosseH ... 2 3/29/2006 8:47:41 PM Address Book button I created a user form that fills in information for a letterhead. Is there a way to add the address book button on to the vba user form. Ideally, I want them to be able to insert a person from their Outlook Contacts (which is already assocaited with the address book button) into a text box on the user form. Any help would be appreciated, thanks. ... 2 3/28/2006 7:31:31 PM Form Field Formats I have a Form Field on my document. The properties are as follows: Type: Number Default number: Maximum Length: 15 Number Format: ### #### #### #### This format is causing me some problems, as the number uses the proper format, but is LEFT justified. I want the format to be used but with the number being RIGHT justified. Example of what I don't want, but is what I'm getting: 123 ... 5 3/27/2006 7:27:25 PM FAQ - Frequently Asked Questions - vba - please read before posting - unofficial March posting FAQ = Frequently Asked Questions - brief - vba - unofficial This FAQ is posted weekly.- more or less Please save us all some time by reading it before posting to the news group. This newsgroup is about VBA - Visual Basic for Applications - which is the programming language for Word 97-2003 (macros). There is a longer FAQ with more questions and links that is regularly posted in the non... 4 3/27/2006 12:48:25 PM Macro for selecting files Hi, I have a macrfo that will open a single word file, extract the data and save it as a csv file - which is what I want. What I now need to do is to make the macro do this automatically for every .doc file in the folder, and I have no idea how to do this. Is this possible and if so can some kind person point me in the right direction thanks A ... 3 4/12/2006 8:52:44 PM Userform for selecting options Hello, My first venture into newsgroups.....man, what have I been missing. I was hoping to seek help on a specific application with Word vba Userforms. I have a good understanding of userforms and tying a userform to a macro, but only a minimal understanging of vba, but I understand programming. An end user wants a word templete for a proposal to bring up a userform with a list of ... 4 4/24/2006 7:03:09 PM 14 Pages: 1  2  3  4  5  6  7  8  9  10  11  12  13  14