Msgbox

Hi All,

I need some assistance in creating a MsgBox when an excel spreadsheet is opened and more specifically a particular sheet is opened.

I'd like the Msgbox to say "Do not forget to select frequency in the blue shaded fields."

I have read a guide which says just add a module in the spreadsheet eg.

PHP Code: 

Sub Msgbox ()

Msgbox "Do not forget to select frequency in the blue shaded fields."

End Sub 


This does nothing and since I am a beginner to vba, I don't know what to do.

A little about the cell: its a Data Validation List containint (Weekly, Fortnightly, Monthly, Quarterly and Annually).

the message should pop up either once they pass the cell OR pop up automatically as soon as that Sheet is opened.

Thank you very much in advance

Please edit your post to add code tags.

Thanks.

Hi Jazzy Max,

Your code is correct, but for it to work on a particular sheet (tab) it needs to be assigned to its the Worksheet_Activate event. To do this, follow these four steps:

1. Copy (Ctrl + C) the following code to the clipboard:

Please Login or Register  to view this content.

2. Right click on the tab name you wish to assign the code to and from the shortcut menu select View Code
3. Paste (Ctrl + V) the code from step 1 into the blank VBA module
4. From the File menu select Close and Return to Microsoft Excel

HTH

Robert

Thank you so much...