Insert the ComboBox control into your sheet then, rather tha
right-clicking the control and choosing Properties, click th
properties button on the Control Toolbox toolbar instead.
About halfway down the list of properties you should see one entitle
'Font'. Click the ... button and select your font size
OK, there's an easier way than going through the Controls Toolbar.
1. Type your ten values into a range of cells (e.g. A1:A10)
2. Name that range MyRange or something similar
3. Select *View > Toolbars > Forms*
4. Select the ComboBox item and draw it on your worksheet
5. Right-click the new ComboBox and select *Format Control*
6. On the *Control* tab, type MyRange as the *Input Range*
7. In the *Cell Link* box, select the cell where you want the item you
user selects from the ComboBox to appear (e.g. $B$1)
8. Click OK
9. Click away from your new ComboBox then select an item from it. Th
item you selected should appear in the cell you chose in step 7 (B1)
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.
