Controls

[Digitborn.com]

Hello,

If you have UserForm1 & UserForm2 on one excel file. On UserForm1 you have TextBox1 and on UserForm2 you have ComboBox2. Is it possible to visualize like this:

Private Sub UserForm1_Initialize()
    UserForm2.TextBox1.Visible = True
End Sub

Private Sub UserForm2_Initialize()
    UserForm1.TextBox1.Visible = True
End Sub

I just wonder why the VBA Editor allows (find) me the control when I'm writing it on the other UserForm... and it's not visualize outside controls (though the same file)!?

 

[xld]

I assume that you mean

Private Sub UserForm_Initialize()
    UserForm2.TextBox1.Visible = True
End Sub

Private Sub UserForm_Initialize()
    UserForm1.TextBox1.Visible = True
End Sub

etc., but what exactly is the question? Are you asking why can you access controls from a different form? If so, they are exposed, so you can do it from a form, a worksheet, or a code module.

 

[Digitborn.com]

Yes, this is one of the 2 questions - Can I access controls from different form and what the point if I cannot visualize them on the form I'd like to access?

The other question is - Is there any chance to visualize a control from another form?

p.s. I just put UserForm1_Initialize() & UserForm2_Initialize() because I wanted to be more clear what i mean.

 

[xld]

I am not sure what you mean by visualize them.

 

[Digitborn.com]

I mean Visible = True