Group: microsoft.public.word.vba.general
From: =?Utf-8?B?SGFycnktV2lzaGVz?=
Date: Tuesday, March 18, 2008 2:23 PM
Subject: RE: Changing position of Userform at Startup



"Jean-Guy Marcil" wrote:

> "Harry-Wishes" wrote:
>
> > Ahh! ! ! I discovered that when I swap my UserForm_Initialize() and
> > UserForm_Activate() code so that UserForm_Initialize appears first, I see my
> > calendar. It works great! ! ! Can't explain why the re-order would solve this
> > problem, but it works.
>
> Glad you got it working... But I must admit I do not understand what you
> mean by swapping the two events. When a userform is called into existence,
> the Initialize runs first (and only once) and the Activate event runs after
> that and everytime the form gets the focus.
> Unless you mean you swapped the code from one event to the other...

Yes. I think that is what I meant. I just switched the modules again and do
not see any change at runtime, just as I had originally predicted. Everything
is clear now.

Thanks again!

Safety Articles | Usenet Groups | Usenet News | Bluegrass