Resizing Userform
 

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

Resizing Userform
 

Hi ExcelMonkey,

Try something like:

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

---
Regards,
Norman


"ExcelMonkey" wrote in message
...
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