userform_activate vs. userform_initialize

J

jey_sea

New Member
Joined
Apr 23, 2010
Messages
24
Whats the differance between the userform_activate vs. userform_initialize commands and if both are present in a user form, which one gets called first?
Thanks
 

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.
Sort by date Sort by votes
initialize occurs first when the form is actually loaded into memory, and activate occurs whenever it is shown.
If you hide then show a form, the activate event will fire again, but initialize will not.
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question
UserForm onActivate does not fire
Replies
8
Views
647
Jaafar Tribak
Jaafar Tribak
K
  • Solved
populating a textbox on a userform from selections that are made from a listbox that is one another userform (popup)...
Replies
4
Views
193
kbishop94
K
B
  • Question
How does one get around Xlookups duplicates vs filters size limitations?
Replies
5
Views
113
BEDE
B
P
  • Question
Runtime Error 13: Type Mismatch
Replies
2
Views
181
NateSC
NateSC
D
  • Question
UserForm_Initialize not being recognized in Commands
Replies
0
Views
470
Denny57
D

Forum statistics

Threads
1,214,859
Messages
6,121,963
Members
449,059
Latest member
oculus

Share this page

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