Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Resizing and Printing a UserForm | Excel Programming | |||
auto-resizing UserForm window | Excel Programming | |||
auto-resizing UserForm window | Excel Programming | |||
Resizing Userform to screen size | Excel Programming | |||
Userform resizing | Excel Programming |