| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change event problems
I have a drop down box (data validation list) in cell E8 and want to run an
edit on the D8 (offset 1 column) if E8 equals "flat" I cannot figure out why my change event won't fire... How do I set up a change event around this code and where should the code be located? THANKS! If Target.Value = "flat" Then ActiveCell.Offset(0, 1) = "No Discount Margin" End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| MenuBar & Event problems | Excel Discussion (Misc queries) | |||
| Change event and calculate event | Excel Programming | |||
| Problems with event handlers | Excel Programming | |||
| change event/after update event?? | Excel Programming | |||
| If... Then Loop problems in Worksheet Event | Excel Programming | |||
Threaded Mode
