OK, I've looked around and seen some ideas on what I'm looking for, but nothing has panned out.
I have a workbook with quite a few tabs on it. In cell C64 is a number from 0.0 to 10 on each page. When selecting any tab, if that particular cell is 0.0 value, then I want a message box to pop up and the focus to be set to that cell.
I've done this in a worksheet_change sub, but I'm failing miserably for some reason.
Does anyone have any ideas? I was trying to do something as simple as :
I have a workbook with quite a few tabs on it. In cell C64 is a number from 0.0 to 10 on each page. When selecting any tab, if that particular cell is 0.0 value, then I want a message box to pop up and the focus to be set to that cell.
I've done this in a worksheet_change sub, but I'm failing miserably for some reason.
Does anyone have any ideas? I was trying to do something as simple as :
VBA Code:
Private Sub Worksheet_Change()
If Range("C64").Value = 0.0 Then
MsgBox "This employee has no points"
End if
End Sub