VBE QUESTION

  • Thread starter Thread starter KOLTZ
  • Start date Start date
K

KOLTZ

HOW DO YOU SET THE MACRO TO EXIT A INPUTBOX MESSAGE
WITHOUT INPUTTING ANY VALUE...(EX. AN ADDRESS BOX THAT ASK
FOR AN APARTEMENT #, BUT THE ADDRESS HAS NO APT# AND YOU
WANT THEM TO HIT ENTER AND GO THE NEXT INPUTBOX MESSAGE)

I APPRECIATE ANY HELP!

THANKS
 
Koltz,

You accidentally left your caps on...

Anyways, why can't the user just press OK on the inputbox without
entering a value? ie...
AptNum = InputBox("Enter apartment number or leave blank if not applicable.")
Then for the address you'd have something like
If AptNum <> "" Then Address = Address & "Apt # " & AptNum

If the user entered an apt# you'd get
123 Bill Street Apt # 222
If not
123 Bill Street

Dan E
 
Back
Top