Assume you have a list in H2:H10 that is displayed in a validation dropdown,
if you do view>toolbars>control toolbox and drag the combobox unto the
sheet, then right click it and select properties the properties window
opens, look for ListFillRange in the left section and put H2:H10 in the box
next to the right of ListFillRange. You also need a linked cell where you
want the selection. You can also change font size etc using this. Finally
click on the triangle to close the design mode
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
