I have an Active X combo box coded in an event procedure on a sheet (ComboBox1_DropButtonsClick). I want to set the combo box's value to a variable like this:
answer = ComboBox1.Value
I then want to pass that variable to the main module so that I can do a select case with the selection. However, the main module does not recognize ComboBox1 as a valid object. How do I pass the combo box's value in a variable from an event procedure in a sheet to a module?
Thanks!
Bookmarks