O
otisjames
Does anyone know how to change the font size in a combo drop down lis
box
box
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
L
Lukin
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
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
O
otisjames
Thank you, that worked but now I'm having trouble getting a list int
the box so I can choose an Item our of the 10 that I have. An
suggestions
the box so I can choose an Item our of the 10 that I have. An
suggestions
L
Lukin
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)
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)
O
otisjames
Thanks!