Most valuable professional
  • Hot Topics

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 Thu, 24 May 2018 10:08:00 EDT.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel