Formating cells

[BT]

Hi,

need a help with cell formating.
Would like to format cells so user cannot input more than 10 caracters into
a cell and than 4 rows with 15 caracters into each cell possible input.
Is this easy to do with excel?

Thanks all
BT

 

[Guest]

Hi,

Yes, use data validation (Data/Validation). Start by selecting the cells
with the same restrictions (10 characters) then go to Data/Validation, select
"Custom" from the drop down menu and type =LEN(A1)<=10 (where A1 is the
active cell) , next click on the "Error Alert" tab and leave a message
stating that 10 is the maximum character that can be typed in that cell.

Repeat for the 15 characters cells and so on......


HTH
Jean-Guy

 

[BT]

Hi,

Yes, use data validation (Data/Validation). Start by selecting the cells
with the same restrictions (10 characters) then go to Data/Validation, select
"Custom" from the drop down menu and type =LEN(A1)<=10 (where A1 is the
active cell) , next click on the "Error Alert" tab and leave a message
stating that 10 is the maximum character that can be typed in that cell.

Repeat for the 15 characters cells and so on......


HTH
Jean-Guy

Thank this works fine
Just another thing, is possible to count the characters down while entering
into cell so I can see how many characters are possible to enter.
BT

 

[Guest]

Hi,

As far as I know No. But I'm not an expert, it might be possible with VBA.
I'm sure someone will let you know if it is.

Best wishes!
Jean-Guy

 

[Sandy Mann]

As far as I know No. But I'm not an expert, it might be possible with VBA.

VBA won't/can't run while you are in edit mode

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk