Prevent users from entering alphabet!

Hi,

I have a doubt, how could i prevent the users from entering a alphabet in a cell ,like people do in java script.

example : there is a field called Quantity, since the quantity field should contain only numbers, i have done this by using data validation (i.e) the user can enter alphabets and it shows the error only after the user enters it.
but i dont want anything to be entered except numbers.

Please help!!!

Thanks

You could do this with the onkey method

If you put the following in the worksheet change event:

Please Login or Register  to view this content.

This isn't 100% as they can still double click on a cell or start with a number and then put alphabetic characters in but it stops them from just starting to type text into a cell.

It would in its current form but you could restrict it to a particular range easily enough. Probably also want to tag on a isnumeric(target.value) to make sure the final output is a number as well.

This would seem to be a x-post ...

http://www.mrexcel.com/forum/showthread.php?t=349064

royuk, I believe (interpret) OP to be using validation already -- I think perhaps there is just confusion as to whether or not an invalid entry is "committed".

Yes, exactly.

Maybe he has the error alert style set to Warning or Info, rather than Stop, allowing the use of alpha characters after overriding the warning.

Hi,
Thanks for ur replies. i'm sorry for the cross post. i'm new and i dont know whether it comes under the rules. can't i post it in more than one forums???

@DonkeyOte royUK - I have used Data Validation, what u said was exactly correct i.e. the user can't enter alphabets and error message will be shown. But this doesn't restrict the user from copying and pasting.
Thats y i went for asking like , it shouln't allow the alpha itself.

expecting a solution here

Thanks

@okriskao

Thanks for the code. Appreciate it. But my requirements is only to use cells...

see a similar thread which in turn has a link to John Walkenbach's solution:

http://www.excelforum.com/excel-misc...alidation.html

this will require VBA to handle the value change though