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.
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.