Murray Brown
asked on
VB.net InputBox Cancel/Closed
Hi
I use the following code to ask a user to enter a row number. If the user clicks the Cancel
button or just closes the box, how will I handle this incode
Dim S As string
S = Globals.ThisAddIn.Applicat ion.InputB ox(Prompt: ="Please enter a row")
I use the following code to ask a user to enter a row number. If the user clicks the Cancel
button or just closes the box, how will I handle this incode
Dim S As string
S = Globals.ThisAddIn.Applicat
Because S is a string,
S = "" when canceled or closed.
S = "" when canceled or closed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Found that out too. Thanks
If sText = "" Then
MsgBox("Cancel or Null")
Else
MsgBox(sText)
End If