Active X controls

Ok, I have a issue understanding how to use the Active X contols. I was trying to create a "combo drop down box", which I can do, I just can not figure out how to assign list of data to it. Anyone know how to do this?

Click on the 'properties' icon on the control toolbox and it will display a
properties window. Look for the ListFillRange property and set that to a
range

e.g $A$1:$A$20

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]HIS


"dksoreal" <[email protected]> wrote in
message news:[email protected]...
>
> Ok, I have a issue understanding how to use the Active X contols. I was
> trying to create a "combo drop down box", which I can do, I just can not
> figure out how to assign list of data to it. Anyone know how to do
> this?
>
>
> --
> dksoreal
> ------------------------------------------------------------------------
> dksoreal's Profile:
> http://www.excelforum.com/member.php...fo&userid=2224
> View this thread: http://www.excelforum.com/showthread...hreadid=383323
>

Thanks for the help. It works fine. I am good to go