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);

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
shouldn't that open and close the workbook?