By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,456 Members | 1,529 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,456 IT Pros & Developers. It's quick & easy.

Excel 2000: Changing page on a multipage control

P: 23
I have a userform in Access/Excel with a Multipage control on. At the bottom of each multipage is a command button that sends you to the next page. When you click these command buttons, it changes which tab has focus at the top of the control, but the other controls on the multipage don't change, they stay as the old page.

code to change page:
Multipage1.value = multipage1.value + 1

I've tried putting form.repaint at the bottom, but that doesn't fix it, any other ideas? It is in Excel 2000, and MS admit to there being such a flaw in 2003, but not 2000.
Dec 22 '08 #1
Share this Question
Share on Google+
5 Replies


NeoPa
Expert Mod 15k+
P: 31,186
I'm not very familiar with Excel forms I'm afraid. I've simply edited the name of the thread to highlight the application it's related to, in the hope that it might attract the attention of some experts who're particularly interested in Excel.
Dec 22 '08 #2

ADezii
Expert 5K+
P: 8,597
@charli
I think it all has to do with the manner in which Controls are placed on the various Pages of a Tab Control. If a Control is placed on a Page/Tab in the traditional way via the Mouse, it will exist only on that specific Page/Tab. If a Control is pulled from the Form Drag/Drop and placed on a Page/Tab, the Control will be visible on all Pages of the Tab Control. If a Control is drawn on a Form then moved to a Tab Control, it will then be visible on all Pages, etc.
Dec 28 '08 #3

missinglinq
Expert 2.5K+
P: 3,532
The real secret is to be sure you've selected a page, as opposed to selecting the entire tab control, then place the control on it. If it already exist on the main form, you have to cut the control, select the page, then paste it.

BTW, how do you have a form in "Excel/Access?" Is it in Excel or Access?

Welcome to Bytes!

Linq ;0)>
Dec 28 '08 #4

P: 23
By Excel/Access I mean I've tried it in both. Originally it was for Excel, when that didn't work I recreated it in Access- only it still didn't work!

If there any way to tell where a control is, whether its parent is the page of the Multipage, or the whole thing? I've tried copying and pasting all the controls onto its-defintely-just-one-page-of-the-multipage, but I still get the error.

Thank you for your replies :)
Jan 16 '09 #5

NeoPa
Expert Mod 15k+
P: 31,186
Charli,

It only makes sense to deal with one at a time as they are clearly different animals and no-one will understand what is being discussed unless you make it clear which one the question is about. It doesn't hurt to mention (clearly, without confusion), that you have tried it in both, but the question can only be about one or the other of them unless you want confusion.

Welcome to Bytes!
Jan 16 '09 #6

Post your reply

Sign in to post your reply or Sign up for a free account.