Value of Cancel button

[snoopy80]

Good Morning!
I have an inputbox I use to request date from users in an Excel sheet. And according what the user enter, it will perform certain fuctions and if the user click on Cancel I want to have an If statement to detect this event and perform other fuctions. I have:

Opt=inputbox("....")

What Opt is equal to when user press the Cancel key?

Thanks for help

 

[PHV]

Application.InputBox returns False if Cancel is clicked.
VBA.InputBox returns "" if Cancel is clicked.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[EBGreen]

Open the VB eidtor in Exel. Press the F1 key. Type the word 'InputBox' then press enter. Click on the first search result. Read and you will find this sentence:

If you click the Cancel button, InputBox returns False.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]

 

[rmikesmith]

Depends on which InputBox you use. If it's the VBA function, it reurns an empty string if the user presses Cancel. Unfortunately, your program can't distinguish that result from one where the user clicks OK without entering anything. I like to use the InputBox Method of the Application object, which returns False if Cancel is selected. See the Help file for syntax.


HTH
Mike

 

[rmikesmith]

Wow, rapid-fire responses!

 

[snoopy80]

Thank you All for Help.
I modified my Inputbox to Application.Inputbox and the Cancel click return False. My codes are working great.

Thanks Again!!!