I have a vba macro that will populate values of checkbox to a cell, the macro saves in C1 anything that were checked... so if the City has check box, C1 will become City, if there are multiple check box selected let say, City, Province and Town, C1 will become City, Province, Town. This works perfectly fine.
[ ] City
[ ] Province
[ ] Town
[ ] District
Now, I have to creat a edit form, where when I clicked edit all of the content in rows will be populated on the designated text box.
I need help on doing the same for check box.
So if C1 has City, then City Checkbox should be cheked, if C1 has City, Province and Town then the corresponding 3 checkbox should be checked as well.
[ ] City
[ ] Province
[ ] Town
[ ] District
Now, I have to creat a edit form, where when I clicked edit all of the content in rows will be populated on the designated text box.
I need help on doing the same for check box.
So if C1 has City, then City Checkbox should be cheked, if C1 has City, Province and Town then the corresponding 3 checkbox should be checked as well.