Discussion Locked

Excel 97 how to change combo box font size ?

0 helpful
9 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Excel 97 how to change combo box font size ?

9 replies

by hersheyboy

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.

by dklippert

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.

by hersheyboy

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.

by dklippert

"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?

by hersheyboy

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 .

This discussion is closed to new replies.