Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger an event when a cell's value is changed.
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger an event when a cell's value is changed.
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Trigger an event when a cell's value is changed.
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
dependant lists- trigger a blank when 1st one is changed? | Excel Discussion (Misc queries) | |||
Trigger Event on Format Change | Excel Discussion (Misc queries) | |||
Trigger Event | Excel Programming | |||
Format Event Trigger (XL2002) | Excel Programming |