View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Graham[_5_] Graham[_5_] is offline
external usenet poster
 
Posts: 13
Default Clear Contents Of A Text Box In User Form

Hi,

I have a text box in a user form for user to enter a
password. A command button is on the user form for the
user to click "OK" when they have entered the password.If
the incorrect password is entered my macro loops around
for the user to try again. However I cannot get my text
box to clear, so if multiple password attempts are
required, a very long text string is created thus making
it impossible to enter the correct password.

Grateful for help on ways around this.

Thanks
Graham