set a maximum number of characters in a cell?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top