Need to open a Message Box from a ComboBox, in Excel 2007
Posted on 2011-09-07
I am trying to write my first VBA function in Excel and do not know how to get the code associated with a given ComboBox. So I thought opening a MessageBox would at least give me confirmation that it was opening correctly.
I already know how to fill a combo box with values.
So, please explain, step by step, how to get to get a given combo box to open a Message Box when a given selection is made on the combo.