DropDown Change Event & Macro

  • Thread starter Thread starter Frank Hayes
  • Start date Start date
F

Frank Hayes

I am trying to use a change to a DropDown Combo Box to trigger a macro.
The DropDown_Change event works well when I make the change to the Combo Box
directly, but if I change the "refers to" cell (e.g. from a 2 to a 3), the
value in the DrowDown box changes, but the event is not triggered, so the
macro never executes.

This is an issue because I have a second DropDown box on a second worksheet
that I am also using to control the "refers to" cell.

Any ideas for making this work ... forcing the macro to run when the "refers
to" cell changes? I do not want to use the worksheet_calculation event as
there are a number of things going on in the worksheet that send me into an
endless loop of calculations.

Thanks

Frank Hayes
 
First a couple of questions.
What version of excel are you using?
What type of combo box are you using? That is are you using the Combo Box
created from the Control Tool Bar which is event driven or the one created
from the Forms Tool Bar?

I have tested the event driven Combo Box from the Control Tool Bar on Excel
2002 and it appears to work fine by either selecting the change in the combo
box or changing the value in the linked cell. However the one from the forms
tool bar only runs when the change is selected in the combo box.

If you are using the control bar tool box with a different version of Excel
and it is still not working, then you might like to try the Worksheet_Change
event:-
Private Sub Worksheet_Change(ByVal Target As Range)

If you have not been using the event driven controls from the control tool
bar and need more info on them then I can recommend Chip Pearsons site at the
following address:-
http://www.cpearson.com/excel/events.htm

Regards,

OssieMac
 
Back
Top