InputBox() associated to the drop-down list

[nadjib]

Hi evreybody,

How can I use the InputBOX() (or syntaxe), associated to a drop-down list.

Contrary to a traditional method, where the user writes a message, I want that it chooses in the list the value to be turned to the program

 

[jebry]

Hi!

To my knowledge you can't. You have a couple of choices:

First, create a popup form with a combo box on it allowing the user to choose from the list and storing the data chosen in whatever way is appropriate for your circumstance.

Second (and not as good), use the InputBox function and compare the input to your list and loop until they match something or give an error message if they don't match.

You can see why the second method isn't as good.

hth


Jeff Bridgham
bridgham@purdue.edu