Dynamically changing form

S

scain2004

I have a form that has a pair of datetime pickers. On every click of
certain command button, I need to add another pair of datepickers an
change the size of the form to incorporate them.

Is this possible? Does anyone know how to do this or know where I ca
find out how to do this?

Thanks,

Stev
 
E

Earl Kiosterud

Steve,

You can make the controls visible or invisible
ComboBox2.Visible = True ' or False
etc.
You can have more than one in the same place.
 
E

Earl Kiosterud

Steve,

I forgot about your other question. You can change the size of the userform
with its height property

UserForm1.Height = 300 ' or just:
Height=300 ' if you're in the code module for the userform

You may not need to make the controls invisible/visible if they're in the
area controlled by the change of height.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Earl Kiosterud said:
Steve,

You can make the controls visible or invisible
ComboBox2.Visible = True ' or False
etc.
You can have more than one in the same place.
Click to expand...
 
Top