VBA selection input question

  • Thread starter Thread starter Just Merks
  • Start date Start date
J

Just Merks

Hello,

Is there an easy way within VBA to ask for a set of predefined test strings?
IE with a pulldown menu?

Inputbox does not provide this mean. I would like to have the user only be
able to make a selection between 5 posible options.

thank you,

Just
 
Maybe you could do this with an input box listing the 1-5 with a provision
that if ans in not numeric or more than 5 to exit sub. If not, use select
case to go on.
 
Hi,

In the spreadsheet the easiest way to provide a list is the Data, Validation
command. But in addition you can look at the Forms toolbar's Combo Box, or
Listbox controls - right click any toolbar and choose Form. Another option
is the AxtiveX controls found on the Control Toolbox toolbar. Here again it
is the Combo Box and Listbox options.

In VBA, on a UserForm is is the Toolbox's ComboBox and ListBox controls.
 
Don,

Thank you. I managed to do it in that way. I was under the impression that
there would be a VB instruction to perform such pulldown function with
predefined parameters.

regards,

Just
 
Back
Top