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?


--
dksoreal
------------------------------------------------------------------------
dksoreal's Profile: http://www.excelforum.com/member.php...fo&userid=2224
View this thread: http://www.excelforum.com/showthread...hreadid=383323

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
HIS


"dksoreal" wrote in
message ...

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


--
dksoreal
------------------------------------------------------------------------
dksoreal's Profile: http://www.excelforum.com/member.php...fo&userid=2224
View this thread: http://www.excelforum.com/showthread...hreadid=383323