Doug Robbins Response Case Property vs UserForm

Doug Robbins Response Case Property vs UserForm_ListBox

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Lenny - 23 Jul 2007 18:52 GMT

Doug: first off - my thanks for your response. The info is great

However, I have a question... can I accomplish the same objective without
the "box"? In my protected template (2003), I have a simple dropdown list
field inside a table cell with 19 Action Codes the user can select from.
Once selected, the item appears in the Action Code cell and the appropriate
Reason Code is automatically dropped into a different cell (Action Code). At
this point it would be relative easy to do with 'case' but it is not exactly
straightforward....some of the items in the list have only one corresponding
Reason Code, others have up to 25 Reason Codes, which the user needs to be
able to select 1 of the 25 which will then be dropped into the Reason Code
block. Are we talking apples and oranges?

Best regards - Lenny

"Doug Robbins - Word MVP" wrote:

> See the Cascading Listboxes section of the following page on fellow MVP Greg
> Maxey's website:
>
> http://gregmaxey.mvps.org/Populate_UserForm_ListBox.htm
>
> Greg also has some information on his site on how to do this with dropdown
> type formfields as used in a protected document.

Reply to this Message

Doug Robbins - Word MVP - 28 Jul 2007 14:03 GMT

For the link to which I did point you, it is a case of apples and oranges.
but for the other one that I said was on the site,

http://gregmaxey.mvps.org/Linked_DropDown_Fields.htm

it would be apples and apples, as you are using dropdown formfields in a
protected document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> Doug: first off - my thanks for your response. The info is great
>
[quoted text clipped - 26 lines]
>> dropdown
>> type formfields as used in a protected document.

Reply to this Message