Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel 2002, WinXP
I am using the InputBox Function to get some info from the user. I want to trap the instance of the user clicking the Cancel button. Clicking on the Cancel button returns a zero-length string. No input and clicking on the OK button also returns a zero-length string. Is there a way to differentiate between the two actions? I realize that I can use the InputBox Method and specify a type and thereby force the user to input something. Also the Cancel button returns a False. Thanks for your help. Otto |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Help with inputbox (Distinguish OK from Cancel) | Excel Programming | |||
Clicking Cancel on an Inputbox | Excel Programming | |||
Inputbox and cancel button | Excel Programming | |||
Cancel button in Inputbox method | Excel Programming | |||
Inputbox method using type:=8 - How to Cancel? | Excel Programming |