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:
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.
Sub ComboBox1_Change() Select Case ComboBox1.Value Case Total MsgBox "Total" Case Products MsgBox "Products" Case Services MsgBox "Services" End Select End Sub
This question generated 12 answers. To proceed to the answers, click here.
This thread is current as of May 24, 2018.