General discussion

Locked

Excel 97 how to change combo box font size ?

By hersheyboy ·
Excel 97 how to change combo box font size ?

This conversation is currently closed to new comments.

9 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by DKlippert In reply to Excel 97 how to change co ...

Use the combo box from the Control toolbar, not the one from Forms

Collapse -

by hersheyboy In reply to

Poster rated this answer.
I used the combo box from the toolbar . There must be another setting somewhere on the worksheet that I inherited m causing the text to remain small.

Collapse -

by DKlippert In reply to Excel 97 how to change co ...

I don't have '97 installed anymore, but there should be two different toolbars "Control Toolbox" and Forms.
The Control version allows the font to be changed.
If the contol is already on the Worksheet, click the design mode icon on the Control toolbox to edit it.

Collapse -

by hersheyboy In reply to

ok now I have a combo box with the correct range and font size, but thr linked cell is also displaying the range item chosen in the combo box.

Collapse -

by DKlippert In reply to Excel 97 how to change co ...

"thr linked cell is also displaying the range item chosen in the combo box."
Yes, that's why it's called a linked cell.
What do you want it to do?

Collapse -

by hersheyboy In reply to

I want to see the line number so that I can use the INDEX function in other cells to scroll through information in adjacent cells to the combo target cells. This was the way the combo box worked from the toolbar menu .

Collapse -

by hersheyboy In reply to Excel 97 how to change co ...

Extra help from DKlippert

Collapse -

by hersheyboy In reply to Excel 97 how to change co ...

Point value changed by question poster.

Collapse -

by hersheyboy In reply to Excel 97 how to change co ...

This question was closed by the author

Back to Software Forum
9 total posts (Page 1 of 1)  

Related Discussions

Related Forums