View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Sam Sam is offline
external usenet poster
 
Posts: 699
Default restrict user to enter 5 digits only

thanks a lot, this worked out great. we can set the max value from property
box, but do you know how we can set min values?

"Eduardo" wrote:

Hi Tia,
Go to visual basic, view object, position in the textbox you want to enter
the limit, then choose Categorized, under Behavior look into MaxLength and
enter 5 there

"sam" wrote:

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

TIA