Max text chrs in cell length

M

mickjj

I am aware that I can specify, using validation, that a
specific cell can have a maximum number of characters.
However this only brings up an error message and gives the
option of cancel or re-try. Is there a way of stopping the
text being typed at the moment the number of characters
reaches the desired maximum number without the need to
retry or cancel?
 
F

Frank Kabel

Hi
AFAIK this is not really possible as no macro an run while editing a
cell
 
M

Myrna Larson

I think you'd need to use a UserForm and VBA code to accomplish this. No way
to do it when typing directly in the cell.
 
Top