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

Hi, everybody,
I want a very simple InputBox, but I want it to be with the InputBox method, to validate the input as numeric and evaluate easyly when it is cancelled by the user. By the way, then I'll do one more validation to the input value, no problem with that.

When I clic OK with nothing in the entry field of the InputBox dialog, I get the same alert you get when you type a formula which contains errors in a cell:
"The formula you typed contains an error.

• For information about fixing...
• To get assistance in...
• If you are not trying..."

It supposed that a blanck entry will yield a 0-length string, perhaps a vbNullString. The variable getting the value is variant. Parameter "Type" is 1.
I made trials with/without default value. And don't want to go to the InputBox function.
Why the hell Excel-VBA thinks anyone is typing anything into a cell?

Attached a sample to reproduce this behavior. Wondering to know from you guys what stupid mistake I'm doing.
Thank you.

Hi, what you want (need actually) is this link https://excelmacromastery.com/vba-inputbox/
Read and learn

The fact you get the 'crazy message' is very simple. The InputBox expects a numeric value and the default answer for Excel when that is not entered is what you will get.

YOU are the one that bwnats to determine what is enetered so do NOT force the type entry if you want other entries or wanht to 'trap' OK .

The check of the entry must be dona AFTER the Inputbox

You test the entry result AFTER you do anything with the InoputBox

Try this file

Right click the cell to open inoutbox

Minor correction applied

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.

Originally Posted by Keebellah

Try this file
Right click the cell to open inoutbox

I should better not put anything in any sheet, to ask my question, but you made a funny game with my named range! It makes the "impossible" message to appear! ("Shouldn't be never printed")
And let me say, I liked very much this dynamic msgbox, telling the left opportunities of entering the value.
I see that you get rid of the "Type" parameter. Then InputBox yields a handleable string, an empty or null one, i. e..

And now this should do the trick, you can enter anything in the cell o the sheet and if it's invalid the userform will appear
I attached a version for 2007 and up so if nobody uses older versions you can use this one (xlsm)
Or else you may stick to the xls but you will get the compatability question when saving

BTW: I implemente ByteMark's solution since it did thetrick

The Type:=1 is okay but you seem to dislike the answer Excel shows as default if the entry is not numeric.
You can avoid all this if you use a simple userform where you can enter only one field with numbers .