I am trying to understand what exactly Frame_enter() or Frame_exit() is for.
I thought that frame_enter meant that as soon as you entered into the frame for anything(checkboxes, textboxes, ect.) that your code would be applied. and the same for when you exit the frame for frame_exit()
example (the code is short, just for this);
shouldn't that open and close the workbook?Private Sub Frame1_Enter() Dim wb as workbook set wb = workbooks.open("path") activeworkbook.sheets("name").activate end sub Private Sub Frame1_Exit(ByVal Cancel As MSForms.ReturnBoolean) wb.close true end sub