What exactly does userform_initialize do?

**crusam** · 08-17-2015, 04:05 PM

I have this Sub where me and my study group have added buttons. It is based on the buttons our teachers have already made (CreateCoffee, CreateDepartment, CreateOwner).
We have created the buttons "CreateCost" and "CreateProject". In this case, It is the button "CreateProject" that is relevant.
We also have to give an explanation of each step in the code and that is the reason why I ask you guys.
We have a problem by understanding what role the "userform_initialize" plays in the code. Can you guys help?

I add the excel file.

**Jack7774** · 08-17-2015, 04:10 PM

Userform_initialize it the very first code that runs and usually brings the form from invisible to visible.

http://www.homeandlearn.org/the_form...ize_event.html

**jaslake** · 08-23-2015, 02:49 PM

Hi crusam

The UserForm_Initialize Code does just that...it set's the initial value of the UserForm Controls. In your specific instance the Code populates ComboBoxId and ListBoxOwner using the AddItem method.

It also sets the Boolean value of NewProject to False.

To test it's impact comment out the UserForm_Initialize Code then click the Button. You'll see that the UserForm still displays but the Controls are empty.

What exactly does userform_initialize do?

LinkBack

Thread Tools

Rate This Thread

Display

What exactly does userform_initialize do?

Re: What exactly does userform_initialize do?

Re: What exactly does userform_initialize do?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] UserForm_Initialize running sub I don't want it to

[SOLVED] Booleans and Userform_initialize()

[SOLVED] Calling a Sub from UserForm_Initialize

UserForm_Initialize() and set up the worksheets

Private Sub UserForm_Initialize() not run

[SOLVED] UserForm_Initialize

UserForm_Initialize error

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions