Texbox index in VBA

S

Seasider

Is there any way to index through a collection of textboxes on a userform ??

Seasider
 
J

Jonathan West

Seasider said:
Is there any way to index through a collection of textboxes on a userform
??

Seasider
Click to expand...

Something like this should get you started

Dim oControl as Control
For each oControl in Me.Controls
If TypeOf oControl Is MsForms.Textbox Then
'oControl is a textbox
Else
'it isn't
End If
Next oControl

--
Regards
Jonathan West - Word MVP
www.intelligentdocuments.co.uk
Please reply to the newsgroup
Keep your VBA code safe, sign the ClassicVB petition www.classicvb.org
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Index into a Table 1
Create Index using VBA in Publisher 2007 0
How do I set focus (and select text) on a text box on a modeless userform? 0
referring to texbox 4
trying to align shifting text boxes 0
Limit the Index to a Section Break range 0
index function in vba 4
Cell that is linked to a Textbox, loses formula? 0

Top