View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default restrict user to enter 5 digits only

Hi,

I simple way is to set the maxlengrh property to 5. Right click the textbox,
properties abd you'll see the propery of maxlength.

Mike

"sam" wrote:

How can we restrict users to enter 5 digits only in a userform textbox?

TIA