Event Procedure - Worksheet_SelectionChange

Hello,

I have an excel with data validation lists in c11 and c19, based on code selected in c11, the drop down list in c19 changes to ones that are linked to that specific value in c11.

I want to add Worksheet_SelectionChange so that when each time the value in c11 is changed, c19 value is cleared automatically.

Can someone plz help me with that?

Thanks!

It seems what you are looking for is Worksheet_Change event with Intesection between Target & cell C11 of the worksheet.

Worksheet_SelectionChange event is fired every time the user changes the active cell by selecting another cell. Worksheet_Change event is fired when any cell is changed by the user or an external link. However, the event wouldn't fire if the cell value changes because of a formula.

Hope this helps !

Originally Posted by LJMetzger

Hi saksmb and Jewel,

I agree with Jewel.

Here are the details:
1. If a cell is changed manually or by VBA, Workseet_Change() is needed.

2. If a cell is changed manually or by VBA and the old value is needed:
a. A global variable is needed to save the old value.
b. Worksheet_SelectionChange() is needed to identify the value of the old value.
c. Workseet_Change() is needed to identify the new value, and possibly take further action.

3. If a range of values is changed by Formula (including a range containing only one cell):
a. A global array of variables is needed to store the old values.
b. The global array needes to be initialized by Workbook_Open().
c. Worksheet_Calculate() is needed to identify which cells in the range changed value.

See the code below or the attached file which implements all of the above.

Lewis

Code like the following needs to be in ThisWorkbook (Formula changes cells):

Please Login or Register  to view this content.

Code like the following needs to be in an ordinary module (Formula changes cells):

Please Login or Register  to view this content.

Code like the following needs to be in the 'Sheet' Module:

Please Login or Register  to view this content.

How do I change this for a range of single cell? i.e. I want it to include the following cells:

"AC6", "AC9", "AC12", "AC15", AC18", "AC21", "AC24"

Any ideas?

darkblueblood,

Please do not cross post as it does nothing but cause confusion. See your original thread for a reply: http://www.excelforum.com/excel-prog...lculation.html

Lewis