Menu
I am using Excel 2010. I would like to chagne the name of an excel form checkbox I've added. How can I do that, not in VBA?
858
Caption Name Vs. Name When you insert a checkbox in Excel, you see a name in front of the box (such as Check Box 1 or Check Box 2). This text – in front of the box – is the Caption Name of the checkbox. To edit this text, right-click and select the 'Edit Text' option.
Right-click the checkbox to edit the text and adjust sizing. To do this on Windows, click File > Options > Customize Ribbon. Then, select the Developer checkbox and click "save." On IOS, click Excel > Preferences > Ribbon & Toolbar > Main Tabs. Then, select the Developer checkbox and save.
Right click the checkbox, and then click Format Control. In the Format Control dialog box, switch to the Control tab, click in the Cell link box and select an empty cell on the sheet to which you want to link to the checkbox, or type the cell reference manually: Repeat the above step for other check boxes.
You can change it in the Name Box:
196
You can do this by editing the name box to the left of the formula bar, here:
24
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
