Script to insert a checkbox into every cell in a column and assign it to that cell
I am working on a project where I need to add a checkbox to every cell which is linked to that cell. When clicked it will return true, when unchecked it returns false into the cell it is assigned to. The worksheet has thousands of cells, and as I'm going through inserting them manually, I realize there has to be a better solution. The sheet I am working on looks like this:
(Excel Worksheet in Need of Checkboxes)
Please let me know if I should be running a script/macro or something - I greatly appreciate your help!
Re: Script to insert a checkbox into every cell in a column and assign it to that cell
The easy way of doing it would be to skip the checkboxes and use datavalidation from a list instead, allowing only 'x' or nothing. A tiny dropdown list will appear as you click a cell.
I can see why you want the checkboxes, the whole setup looks pretty fancy. Are you using forms or ActiveX checkboxes? The activeX ones can be a bit unstable and move around when you zoom.
It is possible to make a macro that will insert checkboxes for you if that's what you really want.
<----- If you were helped by my posts you can say "Thank you" by clicking the star symbol down to the left
If the problem is solved, finish of the thread by clicking SOLVED under Thread Tools
I don't wish to leave you with no answer, yet I sometimes miss posts. If you feel I forgot you, remind me with a PM or just bump the thread.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1