View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Spencer Hutton[_3_] Spencer Hutton[_3_] is offline
external usenet poster
 
Posts: 17
Default text box percent field

is there a way to have a text box on a userform automatically be set up to
receive a percent number amount? a user would be typing in, say...40%. i
would like if the text box could already have a percent sign and whatever
they type in the text box would be followed by that percent sign. i tried,
Userform.TextBox.Value = Userform.TextBox.Value & "%"
but that just repeated itself until the character max was filled. TIA.