Dropdowns to Activex listboxes

  • Thread starter Thread starter hammer300
  • Start date Start date
H

hammer300

Hi All,

I have 8 dropdown boxes on a worksheet that reference an array (A5:A12
on a different worksheet (Player Array) and once a team is selecte
form the dropdown the team members are added into the sheet auto, wha
I want to do is change the dropdowns for activex listboxes so I hav
more control over the properties ie: font size.
How can I do this :( I can get the listboxes there but I cant seem t
get them referencing the array. If you need a copy of the file pleas
let me know.
Any help much appreciated

Thanks

Ro
 
Open the Control toolbox, and click the Design Mode button
Click on a list box, to select it
On the Control toolbox, click the Properties button
In the Properties window, for the ListFillRange property,
enter: Sheet2!A5:A12
 
Back
Top