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

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

use the workshee_change event for this

--
Regards
Frank Kabel
Frankfurt, Germany

"Prasad Vanka" schrieb im
Newsbeitrag m...
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

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 !!!


-----Original Message-----
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
.