PDA

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