Formatting text in labels for check box in Excel
 

I am creating a check box reply in an Excel spreadsheet. I went to View
Toolbars Forms. I clicked on the Check Box tool and clicked and dragged in
the spreadsheet to draw a check box. When I type to label the newly created
check box, I can not seem to change the font, make the text larger, bold,
etc. It looks like it may only be 9 pt. Arial.

Formatting text in labels for check box in Excel
 

hi
if your are draging the check box to the sheet......start over.
go to viewtoolbarsCONTROL TOOLBOX.
locate the check box and drag it to the sheet.
Right click the check box, click properties.
on the properties sheet you can change the font size, color, ect.
the form controls were add to excel to work with user forms.
the sheet controls are much more versital.

Regards
FSt1

"g.a. chubach" wrote:

I am creating a check box reply in an Excel spreadsheet. I went to View
Toolbars Forms. I clicked on the Check Box tool and clicked and dragged in
the spreadsheet to draw a check box. When I type to label the newly created
check box, I can not seem to change the font, make the text larger, bold,
etc. It looks like it may only be 9 pt. Arial.

Formatting text in labels for check box in Excel
 

I see...now I can format the font. Thanks! But now do I have to know Visual
Basic to make the check box work? (to only be able to see or nto see a
checkmark in the box...I do not need to tally any counts at this time).

"FSt1" wrote:

hi
if your are draging the check box to the sheet......start over.
go to viewtoolbarsCONTROL TOOLBOX.
locate the check box and drag it to the sheet.
Right click the check box, click properties.
on the properties sheet you can change the font size, color, ect.
the form controls were add to excel to work with user forms.
the sheet controls are much more versital.

Regards
FSt1

"g.a. chubach" wrote:

I am creating a check box reply in an Excel spreadsheet. I went to View
Toolbars Forms. I clicked on the Check Box tool and clicked and dragged in
the spreadsheet to draw a check box. When I type to label the newly created
check box, I can not seem to change the font, make the text larger, bold,
etc. It looks like it may only be 9 pt. Arial.

Formatting text in labels for check box in Excel
 

Right click on the control, and choose Properties. You can enter a cell
address in the slot for LinkedCell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"g.a. chubach" wrote in message
...
I see...now I can format the font. Thanks! But now do I have to know Visual
Basic to make the check box work? (to only be able to see or nto see a
checkmark in the box...I do not need to tally any counts at this time).

"FSt1" wrote:

hi
if your are draging the check box to the sheet......start over.
go to viewtoolbarsCONTROL TOOLBOX.
locate the check box and drag it to the sheet.
Right click the check box, click properties.
on the properties sheet you can change the font size, color, ect.
the form controls were add to excel to work with user forms.
the sheet controls are much more versital.

Regards
FSt1

"g.a. chubach" wrote:

I am creating a check box reply in an Excel spreadsheet. I went to View

Toolbars Forms. I clicked on the Check Box tool and clicked and
dragged in
the spreadsheet to draw a check box. When I type to label the newly
created
check box, I can not seem to change the font, make the text larger,
bold,
etc. It looks like it may only be 9 pt. Arial.

Formatting text in labels for check box in Excel
 

Yes, I see. Thank you very much for your kind assistance!


"Jon Peltier" wrote:

Right click on the control, and choose Properties. You can enter a cell
address in the slot for LinkedCell.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"g.a. chubach" wrote in message
...
I see...now I can format the font. Thanks! But now do I have to know Visual
Basic to make the check box work? (to only be able to see or nto see a
checkmark in the box...I do not need to tally any counts at this time).

"FSt1" wrote:

hi
if your are draging the check box to the sheet......start over.
go to viewtoolbarsCONTROL TOOLBOX.
locate the check box and drag it to the sheet.
Right click the check box, click properties.
on the properties sheet you can change the font size, color, ect.
the form controls were add to excel to work with user forms.
the sheet controls are much more versital.

Regards
FSt1

"g.a. chubach" wrote:

I am creating a check box reply in an Excel spreadsheet. I went to View

Toolbars Forms. I clicked on the Check Box tool and clicked and
dragged in
the spreadsheet to draw a check box. When I type to label the newly
created
check box, I can not seem to change the font, make the text larger,
bold,
etc. It looks like it may only be 9 pt. Arial.