Re: change drop down list contents based upon value from another list
by 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
asap!
Nate
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,
Corinne
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)