How to create user form using VBA?

[BHawk]

Hello,

I've allready made an user form, and now I want to do something different.

I want that when I press a command button, it creates a new label(#1) and a text box(#1) on the same form. And when I press the same button again, it creates the same label(#2) under label#1 and a text box(#2) under text box#1

Why I want to do this? Because there is no fixed how many labels and text boxes there will be.

I've searched a little bit around and found this: http://www.tek-tips.com/faqs.cfm?fid=5757 but it doesn't work.

Can anyone help me?

 

[Norie]

Why not use a two column listbox?


Then you could have textbox, a combobox and a command button for user input.

The user enters the data using the textbox and combobox and when they click the command button the data is added in a new row in the listbox.

This would allow the user to enter as much data as they need.

You could even add buttons to delete/edit.

 

[RoryA]

I suspect you need to change this:

Me.Controls("text1").Value

to this:

txt.Value

 

[murry]

Thanks. That's a good alternative and I'll go with that if I can't get this to work. I'm dealing with VERY computer illiterate users and have to make input as easy as possible.

 

[murry]

That didn't work either.

 

[murry]

I suspect you need to change this:

Me.Controls("text1").Value

to this:

txt.Value

Sorry forgot to use quote.

This didn't work, not the two column list box.

 

[RoryA]

Didn't work in what sense?

 

[murry]

Didn't work in what sense?

"Object variable or with block variable not set"

 

[RoryA]

I don't see how that's possible with your code. The TXT variable is declared in the same class module and initialised for every class instance.

 

[murry]

me neither

 

[RoryA]

Wait, I just scrolled to the bottom of your code. Are you clicking the Next button when the error occurs? You can't really use the same class for that button.