Excel 2003 - Multipage problem
 

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

Excel 2003 - Multipage problem
 

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

Excel 2003 - Multipage problem
 

I apologize, I was answering a wrong post.

Excel 2003 - Multipage problem
 

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/

Excel 2003 - Multipage problem
 

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

Excel 2003 - Multipage problem
 

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

Excel 2003 - Multipage problem
 

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

Excel 2003 - Multipage problem
 

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

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

Excel 2003 - Multipage problem
 

yep
this looks like a bug.. we'll need some DDT!

multipage1.selecteditem.repaint



keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"?B?RXhjZWxEZXZlbG9wZXJTUFI=?="
wrote:

I am currently having the same problem...was wondering if you have
found a solution? Thanks

"ekwong " wrote:

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 the
problem and attached it here if anyone who has Excel 2003 wants to
take a look. Just run Main sub in Module1 and change the tab in the
form 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
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 *

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

Excel 2003 - Multipage problem
 

this looks like a bug.. we'll need some DDT!

multipage1.selecteditem.repaint

WRONG..s/b

multipage1.Repaint


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool

Excel 2003 - Multipage problem
 

Received the following work around for the set focus problem on
multipage control thanks to Dick of Daily Dose of Excel: Check ou
this link
http://www.dicks-blog.com/excel/2004...ltipage_c.html

please contact me at if you need more info o
making this wor

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