Resizing Userform

[ExcelMonkey]

Is it possible to resize an userform from code. That is, if I drop controls
on a form in the VBE but do not size the form, can I then resize in code at
run-time to accomodate the placement of the controls on the form?

Thanks

EM

 

[Norman Jones]

Hi ExcelMonkey,

Try something like:

'=============>>
Private Sub UserForm_Initialize()
Me.Height = 300
End Sub
'<<=============