GregJG
07-01-2004, 12:45 PM
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?
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?