load userform from a combobox in another userform

**ncaravela** · 09-16-2010, 12:48 PM

Hi there,

I have a wbook with 2 different userform (1 and 2)

I have a combobox in userform 1 that can be filled with numbers from 1 to 10.

in userform 2 i have 10 frames.

I need to load userform 2 after filling the combobox in userform 1

i.e. If i select "5" in the combobox, it should load the 2nd userform with 5 frames visible.

Can anyone help me with this? would it help if i post my workbook?

**royUK** · 09-16-2010, 03:18 PM

I can't see the need for two userforms, but attach the workbook

**Leith Ross** · 09-17-2010, 03:04 AM

Hello ncaravela,

Assuming your Frames are named Frame1, Frame2, ... Frame10 then this will work.

UserForm1 Code - Place this in the General/Declarations section.

Please Login or Register  to view this content.

UserForm2 Code

Please Login or Register  to view this content.

**snb** · 09-17-2010, 03:44 AM

in userform1 a combobox1 and a commandbutton1

Please Login or Register  to view this content.

In Userform2 in the Initialize-event:

Please Login or Register  to view this content.

**ncaravela** · 09-17-2010, 04:57 AM

Thanks all for your help.
however, i'm having some trouble with the code that Leith Ross ent me.
I can't load the second userform when i choose the number in the cbonumero of the first userform.

I'm loading the wb with the code already in it.

Please, if possible, tell me one other thing (Don't mean to push).
I need that the data loaded from the 1st userform goes to the next empty row in the ws "Base Dados", but i also need that the data inserted in the 2nd userform goes to the following rows, under columns (M to P). Is this possible?