-
Jun 17th, 2008, 05:43 AM
#1
Thread Starter
Don't Panic!
[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?
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Mar 5th, 2010, 07:47 AM
#2
Thread Starter
Don't Panic!
Re: [Excel 2003] Multipage control
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?
Last edited by Ecniv; Mar 5th, 2010 at 07:51 AM.
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Mar 5th, 2010, 08:23 AM
#3
Re: [Excel 2003] Multipage control
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
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
-
Mar 5th, 2010, 08:43 AM
#4
Thread Starter
Don't Panic!
Re: [Excel 2003] Multipage control
Yeah - thanks... knew it was simple...
Last edited by Ecniv; Mar 5th, 2010 at 08:51 AM.
Feeling like a fly on the inside of a closed window (Thunk!)
If I post a lot, it is because I am bored at work! ;D Or stuck...
* Anything I post can be only my opinion. Advice etc is up to you to persue...
-
Mar 5th, 2010, 09:03 AM
#5
Re: [RESOLVED] [Excel 2003] Multipage control
Glad to be of help
A good exercise for the Heart is to bend down and help another up...
Please Mark your Thread "Resolved", if the query is solved
MyGear:
★ CPU ★ Ryzen 5 5800X
★ GPU ★ NVIDIA GeForce RTX 3080 TI Founder Edition
★ RAM ★ G. Skill Trident Z RGB 32GB 3600MHz
★ MB ★ ASUS TUF GAMING X570 (WI-FI) ATX Gaming
★ Storage ★ SSD SB-ROCKET-1TB + SEAGATE 2TB Barracuda IHD
★ Cooling ★ NOCTUA NH-D15 CHROMAX BLACK 140mm + 10 of Noctua NF-F12 PWM
★ PSU ★ ANTEC HCG-1000-EXTREME 1000 Watt 80 Plus Gold Fully Modular PSU
★ Case ★ LIAN LI PC-O11 DYNAMIC XL ROG (BLACK) (G99.O11DXL-X)
★ Monitor ★ LG Ultragear 27" 240Hz Gaming Monitor
★ Keyboard ★ TVS Electronics Gold Keyboard
★ Mouse ★ Logitech G502 Hero
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|