Using VBA in Excel97, it is my understanding that the userform's Activate event occurs when the userform becomes the active window. I've performed simple tests to verify this but I've got an application where the Activate event only seems to occur the first time the userform is shown. Once shown and then hidden using the Hide method, the Activate event does not occur the next time the userform is shown.
I've seen something like this on Microsoft's support web page but that problem involved the Deactivate event and a second userform, neither of which apply to me.
Any ideas what may be causing my problem?