Forms Combboxes

[RichardMGreen]

Hi all

I've got two Comboboxes on my worksheet and the second is driven by the first (if you see what I mean).

I would like, if possible, that when the first combobox is changed, that the second goes to the top of the list.

I've looked at the Worksheet_Change event (the comboboxes are linked to cells for other things) but that doesn't seem to work.

Anyone any ideas?

 

[Norie]

Why not try the combobox's own Change event?

If it's from Forms select, right click, Assign Macro...New.

If it's an ActiveX just double click, or select and then View code.

 

[RichardMGreen]

Erm ..... because I didn't know it existed.
Note to self .... do more research before asking stupid questions(!!)