VBE

  • Thread starter Thread starter MEL
  • Start date Start date
M

MEL

HOW DO YOU EXIT A INPUTBOX MESSAGE IF NO INFO IS NEEDED IN
THE BOX.....(EX. INPUTBOX FOR AN APARTMENT #, BUT THEY
HAVE NO APT# TO ENTER)

I APPRECIATE THE HELP!!!!
 
Just ask for something. If they don't type it, the response will be "".


Option Explicit
Sub testme01()
Dim resp As String
resp = InputBox(Prompt:="enter something")
If resp = "" Then
MsgBox "No entry"
Else
MsgBox "you typed: " & resp
End If
End Sub
 
Back
Top