View Full Version : Solved: multipage userform adding pages
mperrah
08-23-2007, 03:31 PM
I'm trying to use a file from jwalks 2007 power programming book.
It uses a multipage userform to simulate a guided form like a wizard.
I have a user form that has a combo box with 16 pages for a help file.
I basically want to add a screen capture to each page.
Attached is a sample
david000
08-23-2007, 06:57 PM
Image1.Picture = LoadPicture _ '<<< (Your path is here...)
like ("C:\Documents and Settings\Owner\My Documents\E X C E L\Working Notes\Clipboard01.gif")
I haven't gotten' around to using this yet, but this function can do the trick.
mperrah
08-24-2007, 08:38 AM
My userform pulls the title and content from a sheet in the workbook,
how can I make the link for the image part of the worksheet too.
Also, how do you set up a multi sheet userform?
In the VBE I see Page1, page2 ... but I dont see how to insert a page.
The sample I'm working with has 4 pages, and I can modify those, but not sure how to add more, (need 16 total with a screen capture image on each)
Do the pages get generated from a macro, or are they manipulated in vbe?
Thanks for your help.
Mark
mperrah
09-03-2007, 07:57 PM
Found it,
the multitab value was hidden.
Click properties look for tab type. make visible.
Right click on the visible tab to choose add page.
Mark
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.