View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike Fogleman Mike Fogleman is offline
external usenet poster
 
Posts: 1,092
Default 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