Is there any way to index through a collection of textboxes on a userform ?? Seasider
S Seasider Jun 19, 2006 #1 Is there any way to index through a collection of textboxes on a userform ?? Seasider
J Jonathan West Jun 19, 2006 #2 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
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
