Active X controls

D

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
 
N

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
[email protected]
 
Top