View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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