descriminate string(letters) values from integer/long (number) values

I need an if statement that can recognize a string (letter/alphabet) values from integer / long (number) values.. Thus if the cell in a column has a number on it, it will flash a msgbox that there's a number...and if the cell contains a string(letters) then it'll do nothing..

Hi,

Not sure what you mean by 'flash a msgbox' since that implies a VBA macro. However why not just use a conditional format in the cell (or column) in question?

In the 'Use a Formula....' option in conditional formatting just enter the formula

Formula:

Please Login or Register  to view this content.

and format with a colour as appropriate.

I created a userform where the employees will enter a 6 digit employee number.. Curently, the textbox doesnt recognize if its a letter or a number.. I'm creating an error msgbox if they enter a number.. How do i do that?

Try with inputbox:

Please Login or Register  to view this content.

You should aslo check is your number 6 digit

thanks zbor,



this works

Please Login or Register  to view this content.

however the above code is a half of what i need, what about another if statement if the input entered on a textbox is a letter? or i mean the counterpart of it?