MSGBox display on open

I've created a new workbook, with a great deal of help from you guys, that I'm ready to put to work. Since it's new and the guys I work with are bout as sharp as I am, I want (Need) to post a MsgBox with instructions on each sheet that pops up as they open it. Any guidance or suggestions? Thanks again.

I would seriously recommend against that. I often put a worksheet called Notes or Instructions in the workbooks that I create so that if a user has a question, he/she has somewhere to look before calling me.

If you put had a messagebox pop up each time the user clicked on a new sheet, your users would quickly get annoyed.

You could put a Help commandbutton on each sheet, so that they could click on that button if they wanted help. Then you could show the messagebox when that button is clicked. That way, it would only happen when the users wanted it to happen.

Your probably right. Hate to spend all the time putting this thing together and have these guys cursing me, every time they opened it.

Thanks.

Instructions for adding a 'Help' commandButton pretty easy?

Thanks for all you guys help. Pretty remarkable you guys donate your time to helping people out struggling with this stuff. Maybe someday I can contribute.

Your probably right. Hate to spend all the time putting this thing together and have these guys cursing me, every time they opened it.

Thanks.

Instructions for adding a 'Help' commandButton pretty easy?

Thanks for all you guys help. Pretty remarkable you guys donate your time to helping people out struggling with this stuff. Maybe someday I can contribute.


I hear 'ya, man. I'm new at all this VBA too.

The Help button can be just a button control you plunk onto the spreadsheet, change it's Name (Insert-->Name-->Define) & Label to Help.

Then goto the Module and give it a simple Click code:

Sub Help_Click()
Sheet("HelpSheet").Select
Range("A1").Select
End Sub

Make sure to give them a "Back Button" that works the same as the help button, only your code Selects "MainSheet" (for eg) so they can go back to where they were...

If you take away their sheet tabs (some people like to do this for several reasons) make sure they have enough buttons (or hyperlinks) to get them from sheet to sheet.

If you do decide to write lengthy instructions (like I tend to do), you could take advantage of the Hyperlink feature, by putting each "Help" topic at the top of the sheet.

(you've seen this on FAQ page on most websites):

A1 would say: "Where do I find my Purchase #" (for eg)
A2 Would say: "When do we have to submit this sheet each week?"

Etc.

Further on down "Sheet2" you have:

(In A27, for eg)
Q: When do we have to submit this sheet each week?
(In A28)
A: Fridays

If you link Cell A2 to A17 via the Hyperlink (Right click on A2 (in this case), choose Hyperlink, choose "Place in this Document" then give A28 as the cell reference). If the user clicks the Topic: "when do we have to submit" in A2 (at the top of the Worksheet) it's take them down to the Answer in cell A28.

Good luck, sir. Hope your co-worker like it. Keep yourself open to their feedback (even if they * * * * *) so you're v2 will be 10X better than the first one...

That sound like the best way. Thanks. Better off keeping it simple. Appreciate the help.