Forum Discussion

theaton56's avatar
theaton56
Copper Contributor
Apr 30, 2020

Excel 365 Checkboxes

Afternoon all, I wonder if someone could assist me with what I hop is a glitch with me ! Inserting a checkbox is fine, assigning the Format Control to a cell to the right of it is fine.  Modifying t...
excel
Zack Barresse's avatar
Zack Barresse
Iron Contributor
Apr 30, 2020
Form controls don't work like that, so what you're asking isn't possible. You have to assign them all manually.
  • theaton56's avatar
    theaton56
    Copper Contributor
    Apr 30, 2020
    Spoiler
    Thanks Zack, had a nasty feeling that may be the case but was hoping otherwise.

    That's is going to be a pain in the posterior and quite time consuming.

    Oh well, the joys of excel.

    Tony




    • Zack Barresse's avatar
      Zack Barresse
      Iron Contributor
      Apr 30, 2020

      Sounds like there may be copious amounts of checkboxes? If so, you can always just use a little bit of VBA to do it automatically. 🙂


       

      Sub LinkCheckboxes()
    
    Dim CheckBoxItem As CheckBox
    
    For Each CheckBoxItem In ActiveSheet.CheckBoxes
        CheckBoxItem.LinkedCell = CheckBoxItem.TopLeftCell.Offset(0, 1).Address
    Next CheckBoxItem
    
End Sub

       

       

      • theaton56's avatar
        theaton56
        Copper Contributor
        Apr 30, 2020

        Thanks Zack,

         

        I will give that a try, was hoping not to use VBA as the end user may screw it up !

         

        Will let you know tomorrow how I get on,

         

        Tony

         

    • theaton56's avatar
      theaton56
      Copper Contributor
      Apr 30, 2020

      Sorry.....

      No idea where that Spoiler header came from !

       

Resources