View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charles Charles is offline
external usenet poster
 
Posts: 1
Default Userform disappears when you try to initialize from a command button

RPIJG

You need to set the values of the textbox to blanks.

textbox1.value = ""

Also you need to set the checkbox or optionbottons to false

userform1.optionbutton1 = False
userform1.checkbox1 = False


This should clear the previous input.

HTH

Charle

--
Message posted from http://www.ExcelForum.com