Active X controls

[dksoreal]

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[dksoreal]

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