InputBox

[vextax21]

Hi, I'm developing and Excel application.

I have a button the leeds to a series of input boxes. The user will input data into these input boxes. I know that when the cancel button is pressed "" is returned by the inputbox. I want to be able to differenciate a blank input from a cancel. For example if a user doesn't put anything inside the input box the result is the same as if the user presses cancel. Can anybody help me here?

thx

 

[fumei]

A suggestion? Don't use inputboxes. Create your own form. That way you can do all the error trapping you want on the text boxes you use for input. You can get rid of a Cancel button if you want (although it is a good idea to have one). If the value of the textbox is "" you can do one thing, if it is not "" you can do whatever else, including alphanumeric checking on the value.

Plus with a form, you can have multiple inputs (including error checking between them) with final checking done with a single OK button - rather than a series of inputboxes, which have to be gone through one at a time.