For an ActiveX combobox from the Control toolbox toolbar, if you limit the
selection to items in the list you can use

if Combobox1.ListIndex < -1 then
' as selection has been made

If you don't want to allow type in entries (required an item in the
list -they can still type that item in), you should set its properties so
they are not allowed.

--
Regards,
Tom Ogilvy

"Amber_D_Laws"
wrote in message
news:Amber_D_Laws.22vppa_1139349003.9848@excelforu m-nospam.com...

In one of my subroutines I want to test for an option in a certian
combobox. It doesn't matter which option the user has choosen, just
that they have chosen one at all.

How do I word the If statement to test for this.

Thanks in advance for any help!
Amber


--
Amber_D_Laws
------------------------------------------------------------------------
Amber_D_Laws's Profile:
http://www.excelforum.com/member.php...o&userid=30012
View this thread: http://www.excelforum.com/showthread...hreadid=509553