Re: dropdown box in form
From: jacinta (anonymous_at_discussions.microsoft.com)
Date: 08/08/04
- Next message: AW: "Multiple Textboxes-Returning Info"
- Previous message: Word Heretic: "Re: Open User form from Document New event problem"
- In reply to: Doug Robbins: "Re: dropdown box in form"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 8 Aug 2004 04:44:34 -0700
I do have the form protected. The text box will only
display the right text when I click on it as well!! I am
obviously doing something wrong here!!!
>-----Original Message-----
>Yes, I ran it on exit from the Dropdown1 formfield.
Unless you assign the
>macro to the keyboard or to a toolbar button, it is not
possible to run it
>in any other way when the document is protected for
forms. That is, you
>cannot use Tools>Macro because the Macro item is not
enabled when protection
>is in place.
>
>So, did you protect the document for Forms? Seems to me
that you may have
>omitted that step and that is why the macro did not run.
>
>--
>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
>"Jacinta" <anonymous@discussions.microsoft.com> wrote in
message
>news:18bd01c47c2b$2e8ee090$a301280a@phx.gbl...
>> Thanks for the reply. Did you run it from the form?
That
>> is where my problem is. I changed to a text box and it
>> made no differnce!
>>
>>
>>>-----Original Message-----
>>>When I run a macro containing the code that you have on
>> exit from the first
>>>dropdown, the second displays the require text.
However,
>> it might be better
>>>to use a text formfield in place of the second dropdown.
>> Your problem might
>>>be that the spelling/capitalization of the words in the
>> code may not match
>>>exactly that of the words in the dropdown lists.
>>>
>>>--
>>>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
>>>"jacinta" <anonymous@discussions.microsoft.com> wrote in
>> message
>>>news:1a4501c47c18$9c021ce0$a501280a@phx.gbl...
>>>>I have created a form in word 2000 and I want a
dropdown
>>>> box to display a particular name depending what the
user
>>>> selects in another dropdown box. When I run the code
it
>>>> works however I cannot get it to work form the form.
I
>>>> have the macro name in the enter box (have also tried
>> exit
>>>> box)of the first dropdown box. Can anyone help. This
is
>>>> the code I am using:
>>>> If ActiveDocument.FormFields("Dropdown1").Result
>> = "high"
>>>> Then
>>>> ActiveDocument.FormFields("Dropdown2").Result
= "joe"
>>>> ElseIf ActiveDocument.FormFields
>>>> ("Dropdown1").Result = "low" Then
>>>> ActiveDocument.FormFields
("Dropdown2").Result
>>>> = "bob"
>>>> ElseIf ActiveDocument.FormFields
>>>> ("Dropdown1").Result = "medium" Then
>>>> ActiveDocument.FormFields
>>>> ("Dropdown2").Result = "henry"
>>>> End If
>>>
>>>
>>>.
>>>
>
>
>.
>
- Next message: AW: "Multiple Textboxes-Returning Info"
- Previous message: Word Heretic: "Re: Open User form from Document New event problem"
- In reply to: Doug Robbins: "Re: dropdown box in form"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|