harveya915
Board Regular
- Joined
- Sep 4, 2015
- Messages
- 141
I have a spreadsheet with vba buttons, code and userforms.
I want to creat a "Help" button inside a UserForm that when clicked opens up a tutorial of how to use the sheet. My dilemma is I don't know what control from the toolbox to use. I tried a text box, but it won't let me format it with Bold characters, different types of font and sizes, indentations and all that word formatting options.
Can anyone recommend a way of accomplishing this?
I had an idea of perhaps typing out the tutorial on to a word document or on to a pdf, then somehow integrating the pdf into excel. Therefore when the button would be clicked the file would open up. I found a couple of dilemmas with this idea that i found after a brief research. 1) I could do a hyperlink. The problem is that the document would be stored on my computer, but since the sheet would be shared with various people the hyperlink wouldn't work. 2) I could insert the pdf into a cell as an icon, this somehow embedding the pdf into the sheet. But I don't want the icon showing on the sheet.
Any help or suggestions would be gladly appreciated.
I want to creat a "Help" button inside a UserForm that when clicked opens up a tutorial of how to use the sheet. My dilemma is I don't know what control from the toolbox to use. I tried a text box, but it won't let me format it with Bold characters, different types of font and sizes, indentations and all that word formatting options.
Can anyone recommend a way of accomplishing this?
I had an idea of perhaps typing out the tutorial on to a word document or on to a pdf, then somehow integrating the pdf into excel. Therefore when the button would be clicked the file would open up. I found a couple of dilemmas with this idea that i found after a brief research. 1) I could do a hyperlink. The problem is that the document would be stored on my computer, but since the sheet would be shared with various people the hyperlink wouldn't work. 2) I could insert the pdf into a cell as an icon, this somehow embedding the pdf into the sheet. But I don't want the icon showing on the sheet.
Any help or suggestions would be gladly appreciated.