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

--
Message posted from http://www.ExcelForum.com

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

I apologize, I was answering a wrong post.

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

--
Regards,
Tom Ogilvy

"ekwong " wrote in message
...
Hello everyone,

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

In my Multipage1_change(), whenever a tab is clicked, I checked if
there is any input error on the original page. If there is error, I
change back to the original page using Multipage1.value = 0 (for
example to go back to the first page). However, after setting
Multipage1.value, only the tab is changed and but not the content of
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


---
Message posted from http://www.ExcelForum.com/

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

--
Message posted from http://www.ExcelForum.com

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


ekwong wrote:
*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

--
Message posted from http://www.ExcelForum.com

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


ekwong wrote:
*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

Attachment filename: testmultipage.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=56023
--
Message posted from http://www.ExcelForum.com