Creating a Workbook help section tips

[rickblunt]

Greetings, I have a WB with some userforms that do a lot of data manipulation. This all works fine but I was thinking that it would be cool to add a "help" button to the userforms, or even for the workbook itself to help the users know how to work the WB. I was typing it up and using screenshots and such to do this but I can't come up with an "elegant" way of incorporating it into the WB. I know I can copy/paste pdf/doc documents right into the workbook, or use hyperlinks - but this seems kind of clunky. Does anyone have any ideas on how to do something that looks more like it does when you use the Excel help section?
I appreciate any input - thanks

 

[Logit]

Here are two examples : UserFormMultiPageHelp.zip

 

[rickblunt]

Thanks Logit (once again )these are great - I was tinkering around with the multipage this morning but wasn't liking it. But now looking at these it makes more sense - I appreciate the ideas.

 

[Logit]

You are welcome. Both examples look good and provide an impressive feature to your project. However, both require a good deal of mental
exercise and time as well.

I've often thought using a hidden worksheet, where everything is wide open to work with, might be an easier approach. Downside ... a worksheet
doesn't look as neat.

 

[rickblunt]

You are welcome. Both examples look good and provide an impressive feature to your project. However, both require a good deal of mental
exercise and time as well.

I've often thought using a hidden worksheet, where everything is wide open to work with, might be an easier approach. Downside ... a worksheet
doesn't look as neat.

yes, a bit more work but it looks very nice and a lot more "native". I think I can covert my jpg's to gifs (i think its gif's...) and then put them in the userform as well - hopefully the pic quality is good enough. I could probably animate that as well