How to create a checkbox?

[Banaticus]

I have an Excel file that has checkboxes in it. When I look at the cell, it shows a letter "c" in it. Just a c. I'd like to add a script that replaces the empty box and puts in a checked (x'd) box. How do I enter a checkbox into a square, empty or checked?

 

[shades]

Howdy. Check boxes are created in two ways.

1. Forms. Go to View Toolbars > Forms

2. Control Toolbox: Go to View > Toolbars > Control Toolbox (be sure to go to Design view prior to trying make the checkbox; then get out of Design view after you finish)

Both will have the checkbox capability. Forms are easier to initially set up. Controlbox gives you much more flexibility in formatting, etc.
________
Honda Today specifications

 

[Banaticus]

I'm adding data to the Excel file from Microsoft Access. What do I put into a cell to get a checkbox?

For instance, if I was just going along in the spreadsheet, typing stuff in this cell and stuff in that cell, how would I enter a checkbox without clicking around in the toolbar?