Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
worksheet change event?
Good afternoon. On Sheet2 of my workbook, I have a table that drives a data
validation list on sheet1. Sheet2 Col A has the status of Open or Closed. Col B has the validation item list. So on sheet1, the list is only populated with the Open items. What I am trying to do is this - if the status of an item on sheet2 is changed to Closed (and therefore removed from the validation list), how can I find that item on Sheet1 and delete it in every cell that it occurs in? I have heard of a worksheet change event, but not familiar with coding it. Thank you in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Worksheet change Event | Excel Worksheet Functions | |||
Change Cell from Validated List Not Firing Worksheet Change Event | Excel Programming | |||
Worksheet Change Event | Excel Programming | |||
Worksheet Change Event | Excel Programming | |||
Worksheet Change Event Help Please | Excel Programming |