set a maximum number of characters in a cell?

P

Peck

i want to set up a database so that each cell has a limit of 30 characters,
so that each address is no more than 30 characters long.
 
H

Harald Staff

Hi

You can have a macro chop off the exceeding characters immediately after the
entry is done. 30 first, 30 last ? But you can do absolutely nothing while
people enter into cells or control which kinds of entries cells accept., and
you can not guarantee that macros are enabled to run by the user.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
How can the font and size of (all) citation numbers be altered? 1
Merging from an Excel file with graphics 1
Problem with MS Word paragraph and character styles: format getting messed up 2
Cell data entering slow! 0
Weigh tasks 0
Autocopy the first cell with more than 30 characters to a different sheet? 1
Adjust cell size for long strings? 1

Top