how to distinguish between cancel and ok with inputbox 5

[Painkiller]

Hi all,

Some time ago I found some code that showed a method that made it possible to find out wether a user pressed 'cancel' or just typed nothing and pressed 'Ok' with an inputbox. Problem is, I can't find the code anymore, and I need it now!

Anybody outthere that knows how to solve this problem?

Much appreciated,

Sujesh

 

[ktighe]

Sujesh,
You can use an if statement like the following to check to see what button the user pushed. You can use the .caption or .text properties of the message box to see if the user typed anything in or not.

If MsgBox(strMsg, vbOKCancel, "Error!&quot = vbOK Then

Go here to see all the possible values that msgbox can return. (vbOK,bcCancel,etc.)

http://msdn.microsoft.com/library/devprods/vs6/vbasic/vbenlr98/vafctmsgbox.htm

Hope this helps,
Kevin

 

[bburnell]

You can also do it this way:

[red] Dim BoxVar As String
BoxVar = MsgBox("Are you sure?", vbOKCancel)
If (BoxVar = vbOK) Then
MsgBox "Done!"
Else
MsgBox "Cancelled!"
End If[/red]

Brett Please visit my websites!

http://www.smsforce.com

http://www.goodguyz.com

 

[WildBillH]

Sujesh --

Your question is about InputBox, not MsgBox...right?

InputBox returns a string. If you click [OK] or just press [Enter], then InputBox returns whatever was entered in the textbox. If you click [Cancel], then the returned string will be empty ("&quot.

WB

 

[ktighe]

Found a page that answers your problem, in case you haven't fixed it yet.

http://161.58.186.98/controls/tip521.html

 

[Painkiller]

Thanks guys for all your replies, the last last reply was actually the one I was looking for (INPUTbox, user types nothing). THanks ktighe!