A blank input to a InputBox (method) runs the alert of typing formula in a cell with error

Originally Posted by Keebellah

... The InputBox expects a numeric value and the default answer for Excel when that is not entered is what you will get.

... do NOT force the type entry if you want other entries...

Keebellah, firstable, I must say that I want to learn the benefits of using InputBox method instead of the function, just because it exists. And the "Type" parameter is the promised diamond shinning at the top of the mountain.

Despite the fact that "Type:=1" makes InputBox to expect a numeric value, entries like "abc", " abc", "/" (strings) kindly tell the user that "Number is not valid" and gives him/her a new opportunity, without extra validation code:

capt1.jpg

In the other hand, a "blank OK" (also a string, null or empty) doesn't produce the same nice effect, nor one space or a string of spaces.



I don't want other entries than numeric ones, but just prevent the possible user's actions. If user clics "OK" accidentaly when nothing is entered, he/she will expect either a new opportunity or a cancellation effect. Even an erroneous validation of "" as a zero could be acceptable by a forbearing user.

What is not understandable is "to accuse" the user of misstyping a formula in a cell, a user that perhaps hasn't never put an equal character "=" in a cell in his whole life:

capt2.jpg

This (certainly crazy) alert is untrappable, unlike errors, to be handled. Yes, I can disable displaying alerts. If I do that, then I lose the kind "Numer is not valid" message when entering strings and I must substitute it with a msgbox with similar text and code to show the box again.

So, the shinning diamond still brights far.