MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Combo Box Problem

Posted by Michael on December 12, 2001 1:39 PM

OK, on a sheet I have 4 combo boxes, what I need to be able to do is pull the values from the combo boxes, and use them in another macor. The names of the combo boxes are still the defaults (combo box 1-4). Does anybody know of an easy way to pull the values and incorporate them?

Posted by Joe Was on December 12, 2001 2:45 PM

In the work space above your first macro define global variables for your values, of the format:

Public X As String

Where "X" is the name and "String" could be any of the available types. You can also place the public global variables in Sheet code, modules or this worksheet depending on how you want to use the variable. You can also "Set" your variable name to the value of your control if needed. JSW