PDA

View Full Version : Range format



tqm1
05-17-2007, 05:41 PM
Dear Experts

In worksheets("Table")
I want to apply following format

Cell C1=must accept NUMERIC value as 99,999
Cell C2=must accpet CHARACTER value
Cell C3=must accept DATE value as dd-mm-yy
Cell C4=must accept LOGICAL value as Y or N

What VBA codes should I apply?

Please help

geekgirlau
05-17-2007, 05:50 PM
Have you tried data validation (Data | Validation)? You can set the type of value you will accept and an error message to be displayed in incorrect values are typed. You then use normal cell formatting to control the display of the data.

lucas
05-17-2007, 09:44 PM
Looks like a class assignment...

Bob Phillips
05-18-2007, 01:40 AM
Looks like a class assignment...

Again? Persistent at least.