Excel: ActiveX ComboBox to drive workbook presentation

Hi all, I would like to use an an ActiveX ComboBox to drive the formatting of the Excel workbook. Particulars of relevance: - ComboBox name: ComboBox1 - ComboBox options: Total, Products, Services What I have thus far:

Sub ComboBox1_Change()
    Select Case ComboBox1.Value
    Case Total
        MsgBox "Total"
    Case Products
        MsgBox "Products"
    Case Services
        MsgBox "Services"
  End Select
End Sub
However selecting the drop-down options in the ComboBox does absolutely nothing pertaining to the Macro. No errors, nothing. My formulas work as expected but nothing from the Macro. Any thoughts? I've spent two full days on it now and I really should do some proper work.

This question generated 12 answers. To proceed to the answers, click here.

This thread is current as of May 24, 2018.

For more resources for Microsoft Excel