Formatting text in labels for check box in Excel

[g.a. chubach]

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.

 

[FSt1]

hi
if your are draging the check box to the sheet......start over.
go to view>toolbars>CONTROL 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]

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).

 

[Jon Peltier]

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

- Jon

 

[g.a. chubach]

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