On 5 June, 20:16, Alfredo_CPA .(donotspam) wrote:
I'm using excel 2003
I have an input box that allows the suer to enter a variable.
I need a code that validates the "type of entry" the user types. I.e. if the
input is a number I need the code to do an specific action, but if the user
types a "legend/word", *I want the code to do a different action.
My problem is not with the if structure, my problem is the code to validate
the type of entry...

--
thanks

Use the ISNUMERIC Function in VBA.