Drop Dow list

W

WhatUp

Is there a way to create a drop down list or a selection box that
would have the user choose whice option they want. like in this case
for the yes, no

Operator = MsgBox(Prompt:="Enter EFH, ESMH or ERT", _
Buttons:=vbYesNoCancel, Title:="Operator")


If iOperator = vbYes Then


Operators = InputBox(Prompt:="Enter EFH, ESMH or ERT", _
Title:="OPERATOR", Default:="Enter EFH, ESMH or ERT")
MsgBox ("here is your request: " & Operators)

The list would be populated for my pre set options then when they
select the one they want in is passed to a variable.
 
Top