Link Multiple Drop Down Boxes Together

Hi Everyone,

So I am trying to make a Word Form that has drop boxes. I would LOVE to have them linked together.

Ex: I Click Warehouse 5191
Then the next box gives the only option of the address for that Warehouse #
Then the next box gives the only option of a city for that Warehouse #
Then the next box gives the only option for a contact for that Warehouse #

Box 1: Warehouse 5191
Box 2: 191 anywhere St., San Francisco, CA
Box 3: Jane Doe P: 999-999-9999

Or is there a way that when I select a Warehouse # and the information will show below it (with next line options)

Ex: Click Warehouse 5191
Appears Below:
191 anywhere St.,
San Francisco, CA
Jane Doe
P: 999-999-9999

Please help, first time making a form.

you do not need anything like that.

If you store your addresses in a structured format on a spreadsheet

use your combobox to select the ware house that you are interested in.

I would populate the Combobox using your list of addresses so that the combobox index number becomes your offset for selecting the address from the table.

Next use your offset to populate a list box.

The code for this is quite easy to understand.

I'll create a sample for you.

Here is your code:-

Please Login or Register  to view this content.

Is there a way to hide the drop arrow for the box? I don't really want it there when I print it.

You could set a button to make the combobox invisible or to cover it with a text box before you print it.

Ok

in this userform. If you click on any grey part of the userform the combobox is hidden by a textbox
if you click again then the combobox becomes visible again.

I have made sure that you cannot change the contents of the text box. but you could disable that bit of code if you need to.

Please Login or Register  to view this content.

By the way

That was a good Question.