events for tabs in a userform?

[spyrule]

I was just wondering if their is a way to set events for when a specific
tab becomes active?

tab1 / tab2 / tab3

if tab1.active = true then

blah blah...
else if tab2.active = true then
blah blah.

end if

stupid example, but it's basically what I'm looking to do.

thanks in advance,

oliver.

[Carim]

Hi,

Do you mean pages in userform ... ?

Carim

[MDubbelboer]

I was just wondering if their is a way to set events for when a specific
tab becomes active?

tab1 / tab2 / tab3

if tab1.active = true then

blah blah...
else if tab2.active = true then
blah blah.

end if

stupid example, but it's basically what I'm looking to do.

thanks in advance,

oliver.

I think this is what you're looking for:
in the userform code:

Private Sub TabStrip1_Change()
MsgBox (TabStrip1.Value)
End Sub

note that the first tab is 0, second is 1, etc.

[spyrule]

Fairly close there MDubbelboer, however it's more like this :


If MultiPage3.tab1.Enabled = False Then
MultiPage4.Enabled = False 'This is a sub multipage control inside the multipage3 control.

Does this clarify at all ?

Thanks in advance,

Oliver.

[theDude]

Oliver,

Try this:

Please Login or Register  to view this content.

Hope this helps,
theDude