Excel vba: create a pop up window with instructions for a worksheet

[pemartins]

Hi,

I was making a tutorial in how to use an Excel worksheet I have, so I decided to make a button with a macro, which when clicked a kind of message box pops up and you can read the tutorial. When you are done you just press ok and the pop up window closes.

Couldn't be easier so I thought, with the very little I know about vba I just have to use msgbox, keep on adding lines with the text and that's it!
But after many attempts I found out that it ain't that easy.

So I made something like this:

Please Login or Register  to view this content.

but at a point I got this error: "Too many lines continuations".

I wanna make something that looks a bit like this:
p69pxC8.jpg
but way simpler, with my text, a scroll bar to roll up and down to read and an ok button at the end. I don't need special text with hyperlinks or anything at all, plain text does the job.

How can I do this?

Thank you very much in advance!

EDIT: it just now crossed my mind, would it be viable to also add a "Print" button next to the "Ok" button in the pop up windows with the tutorial, so when the "Print" button is clicked, the tutorial is printed?

[mahaveersomani]

why are you not using userform for all these things?

[pemartins]

Isn't that obvious?! Because I have no idea of what that is!
Kidding aside, I really don't know much about this...

I'll google it to see what I can find out, but if you could give me some pointers it would be great.

Thank you very much for your help!

[ANDREAAS]

go to developer in excel and select insert at the top, select insert userform, then select view and selct toolbox if it is not already showing also in view select the properties window to show if it is not already showing. on the toolbox, you'll see there are labels that you can use to type your tutorial in. you can also put a button on for close or whatever you feel. to change the text on the labels go to the properties window and chnge the "caption". put a button in you sheet (from insert on the developer tab and coe it with userform1.show. only the basics, but i hope it helps....

[ANDREAAS]

sorry, in the first part there, when you go to developer, click visual basic before you go to insert.

[pemartins]

Thank you very much!

I've been looking at it and I've been trying to put it all together. It's a bit confusing but I'll keep on trying.

I found a code for the close button, which I think it will work:

Please Login or Register  to view this content.

If there a tutorial somewhere that I can use please let me know. Thank you all very much once again!

[ANDREAAS]

check the very first post in the vba section of this forum, there are mucho helpful learning material in there

[pemartins]

Thank you ANDREAAS, I'll browse through it to see what I can find.