Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reset A User Form in Excel 1

Status
Not open for further replies.
roadstain

roadstain

IS-IT--Management
Mar 7, 2002
33
US
How do I reset or clear out all the values entered in a User Form so that they go back to default - or blank. I am sure there is an easy way to do this.

 
Sort by date Sort by votes
I forgot to add - doing this without unloading then reloading the form.

Thanks.
 
Upvote 0 Downvote
For each optionbutton in yourform.optionbuttons
optionbutton.value = 0 (or xloff)
next
For each dropdown in yourform.dropdowns
dropdown.texyt = ""
next

etc etc
HTH
Geoff
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

huiettcm
  • Locked
  • Question
Catching the Mouse Click Error in Modal User Form
Replies
1
Views
211
strongm
strongm
sal21
  • Question
scrping in listbox in a web page
Replies
0
Views
217
sal21
sal21
huiettcm
  • Locked
  • Question
Excel UserForm Window 'Focus' Event Listener 1
Replies
14
Views
349
huiettcm
huiettcm
remeng
  • Locked
  • Solved
Run-time error '429': ActiveX component can't create object From Excel to Word
Replies
9
Views
592
remeng
remeng
remeng
  • Locked
  • Question
Multiple Users in a Macro enabled Excel Doc
Replies
0
Views
151
remeng
remeng

Part and Inventory Search

Sponsor

Back
Top