VB TIP: InputBox - OK or Cancel?

Thursday Sep 19th 2002 by Alan Young
Share:

InputBox - OK or Cancel? You display an InputBox. But did the user press Cancel or OK without entering anything? If you thought there was no way to tell the difference, you're wrong. Step on in to find out how...

You display an InputBox. But did the user press Cancel - or OK without entering anything? If you thought there was no way to tell the difference, you're wrong.

You see, if the user presses cancel, vbNullString is returned. However if they press OK, the empty string ("") is sent back. But in Visual Basic, vbNullString equates to an empty string, so you can't compare the two - even though in reality, they're completely different.

However you can use the StrPtr ('string pointer') function to determine whether the return string is indeed a vbNullString - as by definition, a vbNullString 'pointer' is zero.

And this code demonstrates how to do that.

Code

Dim strInput As String

strInput = InputBox("Enter something:")

If StrPtr(strInput) = 0 Then
	MsgBox "You pressed cancel!"
End If
Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved