InputBox: Cancel/X properties

This macro adds a comment to a cell and some text from an input box. I store the last value entered in the input box via the registry, it is recalled as the default input box value.

How do I capture the cancel property (Boolean, true or false?) so the ActiveCell.Value remains and comment is not added?

When a user selects Cancel/X the macro deletes the value in the cell and add's a comment. This overwrites existing data with "" (nothing).

The VBA help file wasn't very helpful, or, I did not know what to look for.

Please Login or Register  to view this content.

Any hints, tips or examples are appreciated.

If you use Application.Inputbox rather than Inputbox, then the Cancel returns False rather than "". If "" is not acceptable anyway, then uset eh version you have and just check that the length of the returned value is greater than zero.

I think understand your post, but I recall the last value (default value) thus the length will always be greater than zero.

Using application.inputbox sets the cell value to "False" when I use the Cancel button? (overwrites the cell value).

There's no cell value involved - your variable will be set to False if you use the Application version

Now you did it! You made me think!

Thank you.

Please Login or Register  to view this content.