IsBlank in VBA

[wilro85]

Trying to design a check that makes a user insert an integer between 0 and 90.

So far I can use this:

Please Login or Register  to view this content.

to force a numeric value between 0 and 90.

The problem with that code is if the user has a value of "0" in the textbox and hit's backspace it triggers "Only numeric entries allowed", so I need to do something like:

Please Login or Register  to view this content.

But it would seem that isblank is not a native VBA function. I also can't access it if I use worksheetfunction.isblank(). What gives?

The final question is how do I check to make sure an integer is sent in instead of a float (single)? I imagine there should be a function like IsInteger?

[Leith Ross]

Hello wilro85,

You don't the IsBlank method to validate the Text Box entry. All text box entries are text. Just test if the text box value is an empty string "".

Please Login or Register  to view this content.

[royUK]

You can also use the Len Function

Please Login or Register  to view this content.

[wilro85]

Figured it out.

Please Login or Register  to view this content.