UserForm - How Do You Reference

MGumbrell

Registered User.
Local time
Today, 23:26
Joined
Apr 22, 2005
Messages
129
I have a UserForm1 with a MultiPage1 containing Page1, Page2, Page3, Page4, Page5, Page6.

Pages 3 - 6 (inc) Enabled = False.

When UserForm1.OptionButton10.Value = True I need Page3 from the MultiPage Enabled = True.

What I cannot seem to do is reference the Page3.

I have got this far but cannot seem to reference Page3
If UserForm1.OptionButton10.Value = True Then UserForm1.MultiPage1.????

I guess in short, How do you reference a Page within a Multipage?

Regards, Matt
 
Think it is:

Code:
If UserForm1.OptionButton10.Value = True Then 
UserForm1.MultiPage1.Page3.enabled = true
end if
 
Thank you.

So that I can learn something other than just parroting the wisdom that other provide in this forum. I sort of understand the:-
Private Sub Workbook_SheetSelectionChange... (I understand that this proceddure will run when something changes within the worksheet) is this correct?

.....(ByVal Sh As Object, ByVal Target As Range) I sort of understand the Target As Range but lost on the other.

Is there an idiots guide to unravelling this statement? Its such a short code. I would like to understand what it is saying.

Regards, Matt
 
Type byref and byval into google and you will get explanations for the differences, and better explanations than I could probably give.
 

Users who are viewing this thread

Back
Top Bottom