How can I convert a checked checkbox in a cell to text (True) in E

F

ftirman

I have a series of checkboxes in cells. I want to import those checked
checkboxes into Access but it does not recognize checkboxes. To get around
this I need to convert the checked checkboxes to "True", which Access imports
as a checked checkbox. Is there any way to do convert a checked checkbox in a
cell to a text value of "True"?
 
J

JNW

If your checkboxes have linked cells then you can pull the info from the cell
itself. Or you could use code to "read" each check box and place true in a
cell if it is checked.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top