Forms Toolbar Comboboxes are not ActiveX objects. You cannor directly access
their properties using VBA.

Within the associated OnChange macro, you can read the value of the linked
cell.

I think you'd better use a Controls Toolbar Combo.

HTH
--
AP

"m3s3lf" a écrit dans
le message de news: ...

I've searched (and searched and searched), but I can't get the darn
thing to work. I've got a combo box (which I've inserted using the
Form toolbar) and I've given it options and values for said options.
I've written 9 macros that I'd like to have run depending on which
option is selected from the combo box. But I can't get the main macro
(monitoring the combo box and firing any of the 9 macros depending on
it's value) to identify the combo box. Does anybody have some insight?
I'm just about ready to send it to somebody and pay them to fix it...
any takers there?
Thanks in advance!


--
m3s3lf
------------------------------------------------------------------------
m3s3lf's Profile:
http://www.excelforum.com/member.php...o&userid=34874
View this thread: http://www.excelforum.com/showthread...hreadid=552879