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?

"Mike H" wrote:

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