looping controls on userforms

		Microsoft Office Forums > Microsoft Excel > Excel Programming
looping controls on userforms

05-10-2011, 06:16 AM

macropod

Windows 7 32bit looping controls on userforms

Office 2007

Administrator

Join Date: Dec 2010

Location: Canberra, Australia

Posts: 22,521

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]

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to use Building Blocks or controls to add a page	verbster	Word	11	03-06-2011 04:05 PM
Grouping Content Controls	cksm4	Word VBA	2	03-01-2011 12:46 PM
Format picture controls are acting weird.	WaltR	Drawing and Graphics	1	02-11-2011 02:47 PM
hide ghosted controls	designer	PowerPoint	1	01-03-2011 07:11 AM
Can't Download Controls	BillTheAdmin	Project	2	12-05-2005 10:20 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:28 PM.