Query list of objects and properties in VBA

fumei · #1 08-22-2013, 11:03 PM

You do not state what you want to do with this list. Write to another document perhaps. In any case this may help you get started.

Code:

Sub ListCaptions()
Dim oCtl As MSForms.Control
For Each oCtl In UserForm1.Controls
   If TypeOf oCtl Is MSForms.CheckBox Or _
      TypeOf oCtl Is MSForms.Label Or _
      TypeOf oCtl Is MSForms.OptionButton Then
      MsgBox oCtl.Name & vbTab & oCtl.Caption
   End If
Next
End Sub

This gets the values for the controls that DO have Captions. For example textboxes, comboboxes do NOT have Captions. Thus they are not included in the test.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add custom doc properties in "Doc properties control"	eazysnatch	Word	2	09-13-2017 08:08 PM
Convert equation objects to inline objects	sumjoh	Word VBA	1	01-29-2013 08:38 PM
How to Query Text in MS-Excel 2010 or Import Data & Query outside of Excel?	mag	Excel	0	10-18-2012 11:15 AM
Shape Objects	Space Cowboy	PowerPoint	4	10-04-2010 07:14 PM
NOprintable objects	shadowbat	Drawing and Graphics	0	07-05-2010 10:13 PM