ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MultiPage Error (https://www.excelbanter.com/excel-programming/283319-multipage-error.html)

stu

MultiPage Error
 
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?

stu

MultiPage Error
 
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?
.


Dave Peterson[_3_]

MultiPage Error
 
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



All times are GMT +1. The time now is 02:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com