Setting the multipage1.value = anything less than the
active page will select the page TAB but not the page.
Going forward works fine. What's up?
+For example if I have a button on page2

sub but_click()
multipage.value = 0
end sub

the Page1 tab is selected but the Page is not displayed.
The button on Page2 is still visible. However, if the code
reads
sub but_click()
multipage.value = 2
end sub

Page3 is selected and displayed correctly. Is this an
Excel bug?

I guess because I'm a black man no one will answer my
question! I guess that's a 'yes' on both counts.
-----Original Message-----
Setting the multipage1.value = anything less than the
active page will select the page TAB but not the page.
Going forward works fine. What's up?
+For example if I have a button on page2

sub but_click()
multipage.value = 0
end sub

the Page1 tab is selected but the Page is not displayed.
The button on Page2 is still visible. However, if the
code
reads
sub but_click()
multipage.value = 2
end sub

Page3 is selected and displayed correctly. Is this an
Excel bug?
.

I couldn't reproduce this.

In a simple test, the correct page showed up and the userform was displayed
correctly.

If it is a display thing, maybe adding a few:

Me.Repaint

will help.



stu wrote:

Setting the multipage1.value = anything less than the
active page will select the page TAB but not the page.
Going forward works fine. What's up?
+For example if I have a button on page2

sub but_click()
multipage.value = 0
end sub

the Page1 tab is selected but the Page is not displayed.
The button on Page2 is still visible. However, if the code
reads
sub but_click()
multipage.value = 2
end sub

Page3 is selected and displayed correctly. Is this an
Excel bug?

--

Dave Peterson