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!

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

VBA Code command

Status
Not open for further replies.

CuriousGeorge2

Technical User
Aug 5, 2002
27
0
0
US
Can someone please post the VBA code for the following command

clear a user form


Thank you
 
Their is no command, create a Sub that re-initializes the fields on the form to the desired value.
 
True there is no single command. However, depending on what is on the form, you could do a loop through the controls and use the .Clear method to empty each control.

Gerry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top