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