[RESOLVED] [Excel 2003] Multipage control

Hi,

I have some code I am supporting in which the previous coder used a multipage control.

Now I have used tabs before, but not the multipage control.

I am finding it difficult to code wise change the viewed page.

I have four pages that the user can change which is viewing. As records are changed the pages get updated and I wanted to change back to one of hte pages each time.

I found on a google search someone who set the multi pages value to the page number to swap it, and I know the page name. But when I try to find the value of the page there weren't any properties. I just coded in the number of the page as it isn't gonna change. At least not until I add another page in the future may be.


So the question fo someone who uses/has used this control is - with the page name is there a way of making it view without looping through all the pages to match the name?


Or is it just one of those frustrating controls? ;)

Wow.

I have found an old post that asks basically what I am doing now.


In Access there is a tab page control. Useful.
In excel its multipage. But although I manually create the pages the interactions and intellisense for multipage seems to be lacking.

How do I set the page to view via code? (there is no set focus nor activate)


Edit:
Also, why is it that cutting a load of controls to paste into a multipage/tabe strip sometimes loses them so you have to close the workbook and reload it to try again?

Is this what you want?

Code:

---

Private Sub CommandButton1_Click()
    '~~> Say you want to move to page 3
    MultiPage1.Value = MultiPage1.Pages("Page3").Index
End Sub

---

Yeah - thanks... knew it was simple... :)

Glad to be of help :)