Referencing comboboxes in VBA
 

Hi all,

I have a spreadsheet on which will be two comboboxes and my code modul
is dependent on the values from them. So, how do I reference them i
VBA in order to extract the value from them to use in my code?

TIA

Seamu

--
SO
-----------------------------------------------------------------------
SOS's Profile: http://www.excelforum.com/member.php...nfo&userid=540
View this thread: http://www.excelforum.com/showthread.php?threadid=26139

Referencing comboboxes in VBA
 

your variable = ComboBox1.Value

Mike F
"SOS" wrote in message
...

Hi all,

I have a spreadsheet on which will be two comboboxes and my code module
is dependent on the values from them. So, how do I reference them in
VBA in order to extract the value from them to use in my code?

TIA

Seamus


--
SOS
------------------------------------------------------------------------
SOS's Profile:
http://www.excelforum.com/member.php...fo&userid=5406
View this thread: http://www.excelforum.com/showthread...hreadid=261391