UserForm_Initiaize Vs. UserForm_Activate

May 31, 2009

My question is about the difference between UserForm_Initialize and UserForm_Activate. I don't understand what sets them apart. Or why they are used. The reason I ask is, I have made 5 ComboBoxes. Array values are assigned to each combo box.

However, which particular array values are assigned to ComboBox2 are dependent on what the user chooses in ComboBox1. And which array values are assigned to ComboBox3 are dependent on what the user chooses in ComboBox2, and so on and so forth, all the way up to ComboBox5.

My understanding is that all ComboBox values are assigned/populated in the UserForm_Activate procedure. Is this correct? If so, am I right to believe the best/only approach to creating the ComboBoxes I described is by calling the UserForm_Activate procedure everytime a ComboBox value is chosen by the user?

View 3 Replies


ADVERTISEMENT

UserForm_Activate & _Initialise Will Not Run

Feb 21, 2010

I am adding a UserForm to speed data entry for our test engineers. This has 3 pairs of TextBox & SpinButtons for selection of product & test plus the test result. Also an Exit button & 2 labels.

_Initialise & _Activate is supposed to set the text for the TextBoxes plus values for the SpinButtons, default or otherwise.

Neither will run. Have tried location the procedures under Forms & the applicale Sheet, but no avail.

Have now stripped out all the code apart from Message Boxes & some text to try & debug.

What is preventing the routines from running?

View 9 Replies View Related

What Is Difference Between Userform_activate And Userform_Initialize

Dec 11, 2008

I need to understand the difference between userform_activate and userform_Initialize.

When do I use one or the other or both.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved