ActiveX Control Combo box

[NYJets44]

Hi All,

I've created a combo box using activex controls and after making a selection from a drop down list, it does not allow additional buttons to work until I click into an outside cell.

Does anybody have a workaround for this? Any help would be much appreciated.

 

[Jeffrey Mahoney]

Please try this. Make sure to set the LinkedCell to a cell address in the Properties of the ActiveX Combobox

Private Sub ComboBox1_Change()
  Range(ComboBox1.LinkedCell).Select
End Sub

 

[NYJets44]

Hi Jeffrey,

Thanks for your reply. I tried out that piece of code but it kept giving me an error. In fact, I've updated the activex combobox to a form control combobox and the issue was not there.

Is there any workaround for the activex control combobox? It looks better from a design perspective

 

[Jeffrey Mahoney]

So that was a generic macro. Did you name you Combobox? You will need to change Combox1 to Whatever you named yours. Right click on the Combobox and choose View Code