ExcelBanter - Pre-Setting the number of characters input in a whole column

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Pre-Setting the number of characters input in a whole column (https://www.excelbanter.com/excel-programming/428611-pre-setting-number-characters-input-whole-column.html)

tlee

Pre-Setting the number of characters input in a whole column

Hi all,

How can I pre-set the maximum number of characters to input in a whole
column?

If it is excess its limit, the warning message will pop up.

Thanks for in advance.

TLee

Jacob Skaria

Pre-Setting the number of characters input in a whole column

From Menu DatavalidationSettingsAllowTextLength
--
If this post helps click Yes
---------------
Jacob Skaria

"tlee" wrote:

Hi all,

How can I pre-set the maximum number of characters to input in a whole
column?

If it is excess its limit, the warning message will pop up.

Thanks for in advance.

TLee

All times are GMT +1. The time now is 10:55 AM.