Excel 2003 - Multipage problem

E

ekwong

Hello everyone,

I recently upgraded my Office version from 2000 to 2003. While I a
testing my Excel code, I found the Multipage is not working the same a
the previous version.

In my Multipage1_change(), whenever a tab is clicked, I checked i
there is any input error on the original page. If there is error,
change back to the original page using Multipage1.value = 0 (fo
example to go back to the first page). However, after settin
Multipage1.value, only the tab is changed and but not the content o
the page. So now I may have Page1 tab but showing Page2 content.

I have the same piece of code which is working in version 2000. Alway
has the tab matching the page.

Thanks in advance for any help!

Ev
 
D

Diana

Have you considered importing the data in MS Access?

Another way of approaching the issue is to create a pivot in excel based on the data.Before dumping the data in the spreadsheet Excel gives a window asking if you would like a pivot table create. Take this option and this way you would have the data in a summarized version and when you double click on any number you can get the supporting data
 
T

Tom Ogilvy

Sounds like you are having a redraw/repaint problem. You might need to add
the repaint command after you change the tab.
 
E

ekwong

Thanks Tom,

I added the repaint command after I change the page and it stil
doesn't work.

MultiPage1.Value = 0
MultiPage1.Pages(0).Repaint

Ev
 
E

ekwong

Hi everyone,

I still couldn't figure out the solution to get around this problem.
And, I think it is a bug. I have created a simple version of th
problem and attached it here if anyone who has Excel 2003 wants to tak
a look. Just run Main sub in Module1 and change the tab in the for
with error selected as YES or NO.

Also, does anyone know how to report a Excel bug to Microsoft?

Thanks!

Eve
 
E

ekwong

Hi everyone,

I still couldn't figure out the solution to get around this problem
And, I think it is a bug. I have created a simple version of th
problem and attached it here if anyone who has Excel 2003 wants to tak
a look. Just run Main sub in Module1 and change the tab in the for
with error selected as YES or NO.

Also, does anyone know how to report a Excel bug to Microsoft?

Thanks!

Eve

*Hello everyone,

I recently upgraded my Office version from 2000 to 2003. While I a
testing my Excel code, I found the Multipage is not working the sam
as the previous version.

In my Multipage1_change(), whenever a tab is clicked, I checked i
there is any input error on the original page. If there is error,
change back to the original page using Multipage1.value = 0 (fo
example to go back to the first page). However, after settin
Multipage1.value, only the tab is changed and but not the content o
the page. So now I may have Page1 tab but showing Page2 content.

I have the same piece of code which is working in version 2000.
Always has the tab matching the page.

Thanks in advance for any help!

Eve
Click to expand...

Attachment filename: testmultipage.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56023
 
S

sriddell

I am having the same problem with not being able to set the focus to
textbox control on a multipage control...by resetting the value of th
multipage w/ the multipage.value command, it changes the table focus o
the multipage but leaves the controls from the previous page visibl
and doesn't show the page controls that I want to view...if you hav
found a solution, please let me know...I would be so gratefu
 
Top