Home |
Search |
Today's Posts |
#1
|
|||
|
|||
change event on specific cell rather than worksheet
Good morning.
I have an in cell drop down list of vendors that another in cell drop down list of part numbers relates to. I have it set so that only part numbers that belong with a chosen vendor appear. The problem that I have is that if you have already picked a vendor and part number, then change the vendor, the old part number (which does not belong to the new vendor) still remains. Is there a way to clear the part number cell on any change to the vendor cell? (Not on worksheet change as other changes should be allowed without removing the part number.) Thanks for your help! brenda |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I change a cell and cause an automatic change in other cells | Excel Worksheet Functions | |||
copy combobox - cell link to change automatically | Excel Worksheet Functions | |||
Change cell color dependin on date ... | Excel Worksheet Functions | |||
How do I change color of active cell in Excel | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) |