+ Reply to Thread
Results 1 to 2 of 2

Script to insert a checkbox into every cell in a column and assign it to that cell

  1. #1
    Registered User
    Join Date
    10-08-2012
    Location
    Westport, CT
    MS-Off Ver
    Excel 2010
    Posts
    3

    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!

  2. #2
    Forum Expert
    Join Date
    09-01-2012
    Location
    Norway
    MS-Off Ver
    Office 365
    Posts
    2,841

    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.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • 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