VBA On Form Load 表單載入事件

Private Sub UserForm_Initialize ()
         DO_SOMETHING
End Sub

Private Sub UserForm_Terminate ()
         DO_SOMETHING
End Sub

Reference :
VBA Form Load