How to create a dynamic Userform via VBA

S

SuperJas

Hi,

I'd like to create a dynamic userform which can vary the number of inputs depending on the user. A userform will be displayed with 1 textbox to enter their car model. There will be a command button that will allow the user to 'add' more textboxes if they have more cars. Of course I will be placing a limit on the number of cars a person can enter! =)

So my first question would be: is there code which will allow me to resize the userform (eg widen by x lines/pixels/whatever) as the user adds textboxes?

My second question is: is there a relatively simple piece of code which will allow me to add a textbox, say, directly below the one above (maybe with some space in between)?

Thanks very much.
 
T

Tom Ogilvy

Userform has height and width properties.

Look in help at controls.Add

the bottom of the first textbox

sepval = 10
Textbox2.Top = Textbox1.Top + textbox1.Height + sepval

--
Regards,
Tom Ogilvy


SuperJas said:
Hi,

I'd like to create a dynamic userform which can vary the number of inputs
Click to expand...
depending on the user. A userform will be displayed with 1 textbox to enter
their car model. There will be a command button that will allow the user to
'add' more textboxes if they have more cars. Of course I will be placing a
limit on the number of cars a person can enter! =)
So my first question would be: is there code which will allow me to resize
Click to expand...
the userform (eg widen by x lines/pixels/whatever) as the user adds
textboxes?
My second question is: is there a relatively simple piece of code which
Click to expand...
will allow me to add a textbox, say, directly below the one above (maybe
with some space in between)?
 
Top