Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have this code:
MyLocation = InputBox("Enter LTX or EPT", "Pick Option") If MyLocation = "" Or MyLocation < "LTX" Or MyLocation < EPT Then MsgBox "Nothing entered/Cancel or Wrong Location" Exit Sub End If Of course is not working. I need to exist sub if user puts something different than EPT or LTX (the same if user press cancel or press ok without typing anything) I think is not working becasuse the two "Or" exclude the other option (e.g. if user types LTX then Mylocation < EPT...) How can I solve this? Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
using variable from input box | Excel Programming | |||
Variable sum from defined input | Excel Worksheet Functions | |||
Variable Input | Excel Programming | |||
How Macro Ask for Variable Input? | Excel Programming | |||
Input box with variable | Excel Programming |