Trigger an event when a cell's value is changed.

P

Prasad Vanka

Hi,

I have a cell which I am using as a listbox (Went into the Data menu
and selected Data Validation. Then for Validations Criteria under the
Settings tab, I selected list for the Allow: property). This cell can
only take values 1, 2, 3 or 4. That is the user can select a value
between 1 to 4 from the list box.

Now my question:
Is there any way I can trap the event when the value of this cell
changes. For example if the user changes the value from 1 to 2 then I
want to execute a macro. If it is not possible then can someone
suggest me an alternative and also some piece of code.

Your help is much appreciated.

Thanks & Regards,
Prasad Vanka
 
N

Neil

I put a textbox on the worksheet, set as hidden, and link
the value of the textbox to the cell in question, then
put the code against the change event for the textbox,
probably a really poor way to do it, but hey it works for
me !!!
 
F

Frank Kabel

Hi
the worksheet_change event is ONLY triggered if you change a VALUE. So
just selecting the dropdown and not changing the current cell value
will NOT trigger this event (and that is what is to be expected).

Note: In Excel 97 the worksheet_change event is not triggered then the
cell is changed by a drop-down listbox from 'Data - Validation'. In
these cases use a different cell referencing this dropdown cell and use
the worksheet_calculate event
 
Top