change drop down list contents based upon value from another list



  • 1. combining several steps to screenshots
    I have many small screenshots. I want to make each one with a 'square' layout, then with a line around the shot, then make a shadow on the lower right. Is there a way to do this with one macro so I don't have to touch each screenshot 3 times?
  • 2. How do I set up my address book for monthly bill paying
    I have been unable to save names, addresses etc. for printing envelopes. I need help in developing and saving in my address book.
  • 3. Form Fill
    I used Form Fill in Word 97. I am unable to find it in Word 2007. If Form Fill doesn't exist, is there something comparable?
  • 4. I need to create an email account
    I have already installed Microsoft word and I need to set up and email account so I can email letters. How do I do that?

Re: change drop down list contents based upon value from another list

Postby Doug Robbins » Wed, 04 Aug 2004 04:16:51 GMT

You WILL need to use a userform for this and you should decide where you 
will store all of the entries.  I have previously gone through a method of 
doing this with a guy named Phil.  Take a look at the thread in Google at:

 http://www.**--****.com/ +Phil+group:Microsoft.public.word.vba.userforms&hl=en&lr=&ie=UTF-8&group=Microsoft.public.word.vba.userforms&selm=%23L91qu5FEHA.1228%40TK2MSFTNGP11.phx.gbl&rnum=10

Also, take a look at

 http://www.**--****.com/ %40TK2MSFTNGP09.phx.gbl&rnum=20&prev=/groups%3Fq%3DHi%2BPhil%2Bgroup:Microsoft.public.word.vba.userforms%26start%3D10%26hl%3Den%26lr%3D%26ie%3DUTF-8%26group%3DMicrosoft.public.word.vba.userforms%26selm%3DO64cU38REHA.1160%2540TK2MSFTNGP09.phx.gbl%26rnum%3D20

Please respond to the Newsgroup for the benefit of others who may be 
interested.   Questions sent directly to me will only be answered on a paid 
consulting basis.

Hope this helps,
Doug Robbins - Word MVP

Similar Threads:

1.Email Body Changes based on value selected in Drop-Down List

I am trying to do something that seems rather simple, but I cannot get
it to work.  To keep it simple, I just need to proper syntax of how to
return the value selected from a drop-down.

I have a Word FormField Drop-down box with list items already
created.  A user will choose an option and then later I want to base
some actions on that option.

My List box's bookmark name is "Title"

Here is my sample code:

    If Me.FormFields("Title").Result = "Staff" Then
    MsgBox ("Staff")
    End If
    If Me.FormFields("Title").Result = "Manager" Then
    MsgBox ("Manager")
    End If

I dont think .Result is the right option. I have also
tried .DropDown.Value as well and that does not work.  Please help


2.Drop-down List where items in drop-down list hyperlink to a webpag

3.Change text based on drop down list entry

I am trying to have text entered automatically based upon the selection made 
from a drop down list.  Here is what I have so far:

Drop down list items are: Entity A, Entity B, and Entity C
dropdown1 is bookmark name automatically assigned to my drop down list

I have a form field that has the code: 
{ IF dropdown1 = "Entity A" "A" "Not A" }

When "Entity A" is selected in the drop down list, I get "Not A" as a result 
in my form field.  I cannot seem to get "A" to be the result.

4.change color of cell based upon form drop down selection

Is it possible to change the background color (or font) of a cell 
conditionally based upon a selection made from a drop down box within another 
cell of the same table?

5.Drop List Options Dependent On Another Drop Down List Option

I was just wondering if any one was able to help me with this matter.  i am 
currently trying to make it so that I can have a list of options in one drop 
down list, and depending on what gets picked there, make it so that the 
options for the second drop down list correspond with the first.  If this 
does not make any sense, please tell me so, and I will try to explain more.

Thank You,

6. Autofill based on drop down list

7. Automatic entry of information based on drop down list choice

8. Drop-down list based on external data (Word 2000)

Return to MS WORD


Who is online

Users browsing this forum: No registered users and 13 guest