View Single Post
 
Old 05-10-2011, 06:16 AM
macropod's Avatar
macropod macropod is offline Windows 7 32bit Office 2007
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Assuming you're using TextBoxes and you're calling the code from a button or something such on the form, you could implement code like:
Code:
Dim Obj As TextBox
For Each Obj In Me.Controls
  Obj.Text = vbNullString
Next
The above code will clear all textboxes. To clear just a limited set, you could test their names and delete via a Case statement.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote