Frank... Whats wrong...? - well simply put The macro is not running on
the cell until I edit that cell (by pressing F2) or if I enter text into
that cell instead of a formaulae.

To summarise (from the beginning)

User selects from a drop down validation box an option (say option 1)

This displays a word(FAS in this example) in another Cell, say in E4.
I want the attached EVENT to run if cell E4 has a value - so if E4 has
the value FAS, I want to call a Macro called FAS_UNhide. If E4 has ANY
OTHER VALUE (using a simple IF I can make this other value a NO), then I
want it to run another MACRO (called FAS_hide)

Using the Code as reflected below nothing happens UNTIL I MANUALLY GO
INTO CELL E4 and press F2(ie function key 2). I need the event to run
when the cell contents are changed....

Attached code

Private Sub Workbook_SheetCalculate(ByVal Sh As Object)
With Worksheets(1)

End With
End Sub


Private Sub Worksheet_Change(ByVal Target As Excel.Range)

Sheets("Answers").Select

If Target.Address = "$E$4" Then
Application.EnableEvents = False
If Target.Value = "No" Then
Call FAS_Hide
End If

If Target.Value = "FAS" Then
Call FAS_Unhide

Application.EnableEvents = True
End If
End If
End Sub




*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!