I have the following code in a worksheet module. It works well when the value in cell BT2 is changed manually or using a data validation list. I need to change this to a calculation event (I think). The value in cell BT2 will be a result of the formula "=Sheet2!F3"
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Me.Range("BT2")) Is Nothing Then Exit Sub 'Case Sensitive
Select Case Target.Value