I'm trying to refresh a section of a userform once a sub has run.

My code looks something like this:

Private Sub CommandButton1_Click()
Lots of code
Frame1.SetFocus
End Sub

Private Sub Frame1_Enter()
Code to reset everything in this frame
End Sub

However, this method isn't working because the Enter event behaves differently to the GotFocus event. Unfortunately, VBA won't let me use GotFocus for a frame.

Short of integrating the code to refresh the frame into my CommandButton sub (which I don't really want to do as I would actually need to paste it a few times, thereby lengthening my code) does anyone have a solution?

Thanks a million.