Rookie Macro Help

[PumaMan]

Hi,

I created a Macro in MS Word that prompts the user via InputBox. That value
is stored in a variable named State.

I then open certain docs depending on what state it is using a Case
structure (Select Case). However, I am wondering if there is an easier way
to accomplish this? I am having to to create about 40 cases for each state
we support, so any other advice/suggestions would be much appreciated!

Thanks,
PumaMan

 

[Doug Robbins - Word MVP on news.microsoft.com]

Probably better to use a userform with a two column listbox or Combobox that
is populated with the data that the user might enter in one column and the
necessary data in the second column for the required operation to be
performed based on the item that the user selects from the list.

For more assistance, you will need to provide more information.

--
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, originally posted via msnews.microsoft.com