Data Validation

24 May 2005 11:14 AM

tgowrineni

My problem is to set validation for real numbers in the worksheet.
It won't allow text, any special characters like /, % etc. If the user enters data other than real numbers it has to force the user to enter only real number (contents of the cell should highlighted and the cell pointer won't move till the user enters either real number or user can cancel the action).

I succeded upto some level. But, the problem is while I enter the value like 2/5 it is automatically calculating or converting into date value. And, before I choose either retry or cancel the contents of the cell should be highlighted.

If u know the solution for this problem. Please let me know as soon as possible.

Thanks in advance. -- tgowrineni ------------------------------------------------------------------------ Posted via http://www.codecomments.com ------------------------------------------------------------------------

24 May 2005 11:56 AM

Jan Hyde

tgowrineni <tgowrineni.1pj***@mail.codecomments.com>'s wild
thoughts were released on Tue, 24 May 2005 06:14:31 -0500
bearing the following fruit:

Show quoteHide quote

>
>My problem is to set validation for real numbers in the worksheet.
>It won't allow text, any special characters like /, % etc. If the user
>enters data other than real numbers it has to force the user to enter
>only real number (contents of the cell should highlighted and the cell
>pointer won't move till the user enters either real number or user can
>cancel the action).
>
>I succeded upto some level. But, the problem is while I enter the value
>like 2/5 it is automatically calculating or converting into date value.
>And, before I choose either retry or cancel the contents of the cell
>should be highlighted.
>
>If u know the solution for this problem. Please let me know as soon as
>possible.
>
>Thanks in advance.

This doesn't sound like a VB problem. I could guess your
talking about Excel in which case one of the Excel groups
might be better?

Jan Hyde (VB MVP)

--
Why is marriage like a violin?
When the beautiful music is over, the strings are still attached.

(Renee from Napa)

[Abolish the TV Licence - http://www.tvlicensing.biz/]