View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default 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