Userform CheckBoxes

  • Hello,


    Very probably ... you are probably missing the link between the sheet and the userform ...


    But ... honestly ... just take a few seconds about it ....


    How on earth are you going to get a fully operational solution ....WITHOUT ... attaching your file ...????:question:

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi,


    Thanks for the file ...


    Your problem comes the many different persons who have amended one after the other both the UserForm and its code ...


    Below is a modified macro for the Technician Update data :



    Hope this will help

    Files

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)

  • Hi Carim


    Thanks for the feedback. Your suggestion has worked. However If I delete the True and False values on the sheet , why is the userform still displaying ticks in the checkboxes?

  • Hi Carim


    Thanks for the feedback. Your suggestion has worked. However If I delete the True and False values on the sheet , why is the userform still displaying ticks in the checkboxes?


    Glad the modification worked as expected ...


    Regarding the other way round ... when you modify the worksheet ... the UserForm gets re-initialized with its own procedure ... which does require the same cleaning which was performed for the Update procedure ...


    Hope his clarifies

    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner:)