Excel Code running twice unintendedly when A checkbox is added to Chain code together
I have a few blocks of codes, made to assist a user to automate defect capturing. I have a userform, and that form has a listbox called ScreeningDefectList. I have a button called Fail and a box called SelectedDefect. When user selects an item in ScreeningDefectList, the SelectedDefect gains the value of the list index (lets say list index of 1 is a cut, then SelectedDefect will have the text “Cut”).