Feed dynamic optionbutton selection to specific cell

  • Hi,


    I am struggling with addressing a challenging issue...


    I have developed code that creates a UserForm with a dynamic amount of checkbox. I am trying to assign a True/False value to specific cells for each checkbox that is/isn't selected.


    For the most part, this is where my code begins:



    This is where I am having the issue (class module):


    Code
    1. Option Explicit
    2. Public WithEvents CheckGroup As MSForms.CheckBox
    3. Private Sub CheckGroup_Click()
    4. Range("BA1") = CheckGroup.Value
    5. End Sub


    I am unable to figure out how to assign each checkbox to specific cell. More specifically, I am unable to determine the "name" of each checkbox is so that I can assign them...


    Any help would be appreciated


    Thank you

  • Re: Feed dynamic optionbutton selection to specific cell


    Hi,


    I have run into a dead end and was hoping to receive some assistance....


    The attached file produces a userform that utilizes code which dynamically adds checkboxes. When macro is initiated, the checkboxes appear and are checked off if their corresponding cells in column BA are tagged as True.


    In addition to having the checkboxes populate with existing entries that are booked to column BA, I am trying to do the reverse. I am hoping to feed corresponding cells within column BA when checkboxes are clicked (Feeding corresponding cells with True or False).


    I am desperate for some guidance - - please help!!


    Thank you in advance


    [ATTACH=CONFIG]70769[/ATTACH]

    Files

    • Test.xlsm

      (47.92 kB, downloaded 74 times, last: )