Make a string an object?

[starl]

Isn't there a way of making a string an object?

example: I have objects: Form1, Form2, Form3
I want to run them thru a loop. So, I create a string "Form" & counter...
but how can I get that to become the object?

why am i doing this... cause I have several forms to clear - some have up to 20 boxes... and to have to clear each one....
Could swear I read there was a way..unless I totally misunderstood!

thanks

 

[Richie(UK)]

Hi starl,

Are you looking to perform an action on ALL of the forms or just some of them? If its all of them try using 'For Each' to loop through.

 

[starl]

a little confusion on my part..
I have a multipage form - mixture of comboboxes and textboxes.
I want to clear SPECIFIC boxes - not the entire page of the form.
My use of "Form" was just a way of referring to the different types of boxes.

 

[starl]

ok - so how can I use the For Each to go through the comboboxes on a page of my form??? I couldn't figure out what the collection is..

 

[Richie(UK)]

Hi starl,

From the VBE Help section:

You can access the collection of controls on a UserForm using the Controls collection. For example, to hide all the controls on a UserForm, use code similar to the following:

For Each Control in UserForm1.Controls
Control.Visible = False
Next Control

HTH

 

[Mudface]

From within the UserForm module, something like this would cycle through (eg add this to a command button's click event to clear the comboboxes, or use it in the userform's Terminate event, use the UserForm1. qualifier rather than Me. if you're doing it outside the UserForm module etc etc): -

Dim ctr As Control

For Each ctr In Me.Controls
    If TypeName(ctr) = "ComboBox" Then MsgBox ctr.Name ' do your stuff here
Next ctr

 

[starl]

*lol* thank you both.