userform_active / _open help

**twoben** · 10-31-2011, 05:13 AM

Hi.. Need help with something that should be easy..

I want a sub to activate when i open my userform..

Ive tried _open, _initilize,_ Activate but must be placing the code in the wrong place..

I have a macro that looks like this

Please Login or Register  to view this content.

'In Menu1 "userform" ive added

Please Login or Register  to view this content.

But the box wont show.. where do i place the code or how do i write the sub to enable the code without click requirement.. (the end i want a lable to start changing when i start the userform but first i need to learn how to start without click)

**Kyle123** · 10-31-2011, 05:40 AM

it should read like this, regardless of what you have called your userform. Rather than typing for events, select the object from the top of the window, then select the event

Please Login or Register  to view this content.

**twoben** · 10-31-2011, 06:37 AM

Thanks for the quick solution...

**pike** · 10-31-2011, 04:27 PM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save