If Target.Address = "Question_Number" Then
should be

If Target.Address = Range("Question_Number").Address Then

Unless 3 is the only number to consider, you would have to store and
maintain the starting value. You would probably do that in a static
variable, but it is unclear when the "start" has occured.

for general information on events:

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"Neil Goldwasser" wrote in
message ...
Hi! I have a cell named "Question_Number" which can take any integer value
from 1 to 20.

There are several ways to change the value of this cell:
1) Typing in a new number manually
2) Using the scroll bar to increase or decrease the value
3) As a result of various macros from pressing buttons within the sheet.

I'd like to be able to trigger an event if this value alters. E.g. if it
was
previously 3, and it is then increased or decreased. If the macro puts a 3
back in, or the user types 3 into the cell manually, I don't want anything
to
happen.

I have already written the code for the changes I want to take place
afterwards, but don't know enough about events and coding to get the event
triggered in teh first place.

Any chance somebody could show me the code I need to put in?

Does it start as follows?...


Private Sub Worksheet_Change(ByVal Target As Excel.Range)

If Target.Address = "Question_Number" Then
Application.EnableEvents = False
If Target.Value ........
etc...
Else
etc... (do I put a "Nothing" or something like that here?)
End If
Application.EnableEvents = True
End If


Or am I completely wrong with this?


Also, how would I adapt it if I wanted the event to be triggered even if
the
same value is put back in e.g. it was previously a 3, the macro gives
another
3 and the event still triggers?

I'd be very grateful for some help!
Thanks, Neil