Max text chrs in cell length

  • Thread starter Thread starter mickjj
  • Start date Start date
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?
 
Hi
AFAIK this is not really possible as no macro an run while editing a
cell
 
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.
 
You must log in or register to reply here.

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

Max Length in a row 1
Set max characters in cell (Excel 2007) 4
setting a cell length limit 1
how do I set a maximum characters in a specific cell 2
Cell format - wrap text 7
Maximum Text in Cells for Printing 1
How many characters in text box in Excel 2007? 1
Total Text Length of Adjacent Cells 6

Back
Top