Procedure Declarations Equal to Initialize and Activate

imav

New Member
Joined
Jun 27, 2011
Messages
21
:confused:What is a procedure that acts the same as Userform_Initialize() and Userform_Activate()?

I have tried typing my own as Userform_Initialize2() but it does not work.

I just need another procedure that will run when the form is opened other than those 2.

Please help.

imav
 

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Can't you call your Sub from UserForm_Initialize?
Code:
Private Sub UserForm_Initialize()
    Call UserForm_Initialize2
End Sub

Private Sub UserForm_Initialize2()
    ' Some code...
End Sub
 
Upvote 0
I dont know why i didnt think of that. Thanks so much. I also found another declaration that will allow you to autorun what is below it when the userform opens. they are

Code:
Private Sub Userform_Layout()
 
and 
 
Private Sub Userform_MouseMove()
~mousemove isnt instant, it requires you to shift your mouse by a pixel or so but the need is unnoticable~
 
Upvote 0

Forum statistics

Threads
1,215,452
Messages
6,124,915
Members
449,195
Latest member
Stevenciu

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top