Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
hey guys
I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
Sounds like you are using a tabstrip control rather than a multipage.
-- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... hey guys I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
No because I selected Multipage control and drag and
dropped it there from the control box. Do I need to insert the multipage control before any other control maybe? -----Original Message----- Sounds like you are using a tabstrip control rather than a multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... hey guys I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
When a multipage control is dropped on a useform, the default is two pages.
When you click on the second page, you have a clean surface to place other controls on. What you describe is typical of a tabstrip. Other controls on the userform itself should have no effect on the functioning of the multipage. Controls on page1 of the multipage should have no effect on operation of page2 of the multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... No because I selected Multipage control and drag and dropped it there from the control box. Do I need to insert the multipage control before any other control maybe? -----Original Message----- Sounds like you are using a tabstrip control rather than a multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... hey guys I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
You do have to put your controls on the pages of the Multipage.
Todd Huttenstine wrote: No because I selected Multipage control and drag and dropped it there from the control box. Do I need to insert the multipage control before any other control maybe? -----Original Message----- Sounds like you are using a tabstrip control rather than a multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... hey guys I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine . |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
Ok I guess this shows how much I know about using
multipage controls... What happened is I inserted the multipage control on the form and only drug it across the top of my form. I thought there was some special way it would know to bring up another page so it appeard as though it was not working. Then I had the idea to pull the multipage control down. It covered up my other controls so I just brought them onto the multipage control. Then I clicked the tabs again and now I can see it working. Todd -----Original Message----- When a multipage control is dropped on a useform, the default is two pages. When you click on the second page, you have a clean surface to place other controls on. What you describe is typical of a tabstrip. Other controls on the userform itself should have no effect on the functioning of the multipage. Controls on page1 of the multipage should have no effect on operation of page2 of the multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... No because I selected Multipage control and drag and dropped it there from the control box. Do I need to insert the multipage control before any other control maybe? -----Original Message----- Sounds like you are using a tabstrip control rather than a multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... hey guys I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine . . |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
Ok I guess this shows how much I know about using
multipage controls... What happened is I inserted the multipage control on the form and only drug it across the top of my form. I thought there was some special way it would know to bring up another page so it appeard as though it was not working. Then I had the idea to pull the multipage control down. It covered up my other controls so I just brought them onto the multipage control. Then I clicked the tabs again and now I can see it working. Todd -----Original Message----- When a multipage control is dropped on a useform, the default is two pages. When you click on the second page, you have a clean surface to place other controls on. What you describe is typical of a tabstrip. Other controls on the userform itself should have no effect on the functioning of the multipage. Controls on page1 of the multipage should have no effect on operation of page2 of the multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... No because I selected Multipage control and drag and dropped it there from the control box. Do I need to insert the multipage control before any other control maybe? -----Original Message----- Sounds like you are using a tabstrip control rather than a multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... hey guys I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine . . |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
MultiPage Control
Todd,
If you want to add another page to the standard two-page multipage control, just click Page1 or Page2 with the right side of the mouse. Then you'll see that you can easily expand the number of pages that you'll need to do your work. Years ago, I actually created those extra pages programmatically (when I had too much time on my hands). Later, I learned the easy way that I described above. I hope that answers your original question. Rick -----Original Message----- Ok I guess this shows how much I know about using multipage controls... What happened is I inserted the multipage control on the form and only drug it across the top of my form. I thought there was some special way it would know to bring up another page so it appeard as though it was not working. Then I had the idea to pull the multipage control down. It covered up my other controls so I just brought them onto the multipage control. Then I clicked the tabs again and now I can see it working. Todd -----Original Message----- When a multipage control is dropped on a useform, the default is two pages. When you click on the second page, you have a clean surface to place other controls on. What you describe is typical of a tabstrip. Other controls on the userform itself should have no effect on the functioning of the multipage. Controls on page1 of the multipage should have no effect on operation of page2 of the multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... No because I selected Multipage control and drag and dropped it there from the control box. Do I need to insert the multipage control before any other control maybe? -----Original Message----- Sounds like you are using a tabstrip control rather than a multipage. -- Regards, Tom Ogilvy "Todd Huttenstine" wrote in message ... hey guys I need to use a multipage control and I cant figure out how to make that extra page for my second tab. I have already created my userform, then I realized I needed to add another category, so I inserted a multipage control on the userform. I have already named my tabs. One says "Publish" and the other syas "backup". Now as far as the "Publish" form is concerned, it is complete. Now how do I set it up so when I click the second tab, "Backuo", it goes to a blank page of the form where I can start adding more controls? Thank you Todd Huttenstine . . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MultiPage control | Excel Worksheet Functions | |||
hide a page on a multipage control | Excel Programming | |||
Events for Controls in a Multipage Control | Excel Programming | |||
MultiPage control | Excel Programming | |||
Multipage control | Excel Programming |