Popup warning when swithcing sheets in workbook

[ARy1229]

Hi all, I am generally pretty good with Excel but I havenever worked with visual basic or writing macros. In my current role I ambuilding a template for project managers to use to forecast. One of the itemsis to check the number of people forecasted against the prior month peopleworked. I did a formula to determine the variance over/under by decimal andwould like to have a pop up appear to point out that the variance is 10% offfrom prior month trend. Is this even possible?
THanks.

 

[rpaulson]

try this.

Right click on the sheet name - view code
Paste this in

Private Sub Worksheet_Activate()
If [A1] >= 10 Then MsgBox ("variance is 10% off from prior month trend.")
End Sub

when you activate that sheet AND cell A1 is greater than 10 you will get them message.

hth,

ROss