ExcelBanter - how do I set a maximum characters in a specific cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - how do I set a maximum characters in a specific cell (https://www.excelbanter.com/excel-discussion-misc-queries/247658-re-how-do-i-set-maximum-characters-specific-cell.html)

T. Valko

how do I set a maximum characters in a specific cell

Check out DataValidationAllowText length

--
Biff
Microsoft Excel MVP

"ochie" wrote in message
...
Is there a non-VBA way to set a maximum number of characters in a specific
cell?

All times are GMT +1. The time now is 10:40 PM.