Excel 2003 - Multipage problem

  • Thread starter Thread starter ekwong
  • Start date Start date
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
 
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
 
Sounds like you are having a redraw/repaint problem. You might need to add
the repaint command after you change the tab.
 
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
 
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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multipage default open 7
Confusion on Multipage Tabbing 2
multipage 2
Writing code to objects within MultiPage object 2
No Multipage pages are active on startup 3
Excel VBA Multipage 0
Multipage 0
MultiPage Scroll Bar 3

Back
Top