Run the code on opening the userform

[ABSTRAKTUS]

Hi all,

This I think will be a quick and simple one.

I have several objects on a userform (textboxes, comboboxes etc.). They all depend on combobox1. If combobox1 is = "" all other objects are being locked and greyed out.

Problem:

When I load the userform, all objects are blank and active even if combobox1 is blank, but it only takes to type something in it and delete - code is then being executed. I need my code to execute when I actualy load userform.

Any help please?

Thanks!

[AlphaFrog]

Please Login or Register  to view this content.

This procedure automatically runs when the UserForm loads. Do not change the name of the procedure to the name of your userform.

Alternatively, you could change the default Enabled property (= False ) of each control in the VBA Properties window.

[ABSTRAKTUS]

Hi again AlphaFrog,

Thanks for the resonse. Where do I put this code? In ThisWorkbook? In Module? In one of the tabs?

Sorry to be a pain, I'm still learning...

[AlphaFrog]

In the UserForm's code module.

[ABSTRAKTUS]

Good, as always.

Thanks Alpha!