GotFocus event won't trigger

Should work, you're not in design mode? There are also some ActiveX options in the trust center settings, also its definately called that, try rightclicking on it in design mode and view code, see where it takes you.

Why not populate the comnobox using another event, for example the worksheet Activate event?

If you use one of the combobox's own events the user might notice a small lag while the code is running to populate it.

You ask a good question, Norie. The reason is that the contents of the ComboBox (it's list items) may change depending on the contents of other boxes, as I'll try to explain.

On the worksheet I have two ComboBoxes: "cb_cpn" and "cb_company". The idea is that users can use these to select a row of data from another worksheet, by either campaign or company. So, if, at first, the user selects 'Campaign A' from "cb_cpn", they are then able to select companies 1 - 8. Conversely, if a user selects "Company 5" from the "cb_company" control, they may only select "Campaign A" or "Campaign C" from cb_cpn" (see image below). Additionally, the source data in the hidden sheet will be changed indirectly by the user throughout operation.

cpn comp.png

Does that make sense? If so, is there a better way to achieve the same (I must say that, throughout my own testing, I could not notice any lag -- that is, when it was working).

I thought that might be the case, and what I'd suggest is that if a combobox is dependent on another combobox/control put the code for populating the dependent combobox in the 'parent' combobox/control.

So in your case you would put the code to populate cb_company in the change event of cb_cpn.

PS Hope I got that the right way round.

Sorry I've don't really know what could have caused that to happen.

Has anything changed in the sheet?

Is it protectd/locked in any way?

As for both comboboxes being 'parent' controls, I don't see a problem with that.

Do you use code like this anywhere?

Please Login or Register  to view this content.

Otherwise I would restart excel and see if any event capture returns.

If SelectionChange isn't working then it could mean events are disabled, which isn't something I would have thought would affect controls.

Anyway, try enabling events by entering this in the Immediate Window in the VBE.

Please Login or Register  to view this content.

GotFocus is one of the few ActiveX events that is affected by EnableEvents.