ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How can I convert a checked checkbox in a cell to text (True) in E (https://www.excelbanter.com/excel-programming/394136-how-can-i-convert-checked-checkbox-cell-text-true-e.html)

ftirman

How can I convert a checked checkbox in a cell to text (True) in E
 
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"?

JNW

How can I convert a checked checkbox in a cell to text (True) in E
 
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.
--
JNW


"ftirman" wrote:

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"?



All times are GMT +1. The time now is 02:56 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com