| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Matching multiple userform height and widths after resizing
I have added max and min buttons on my userforms and I would like to
make the next userform the same dimensions as the previous form if it was maximized. Please help! thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching multiple userform height and widths after resizing
If you aare using VBA userform, go to VBAProject and right click the
userform. You can import and export userforms. "melissa" wrote: I have added max and min buttons on my userforms and I would like to make the next userform the same dimensions as the previous form if it was maximized. Please help! thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching multiple userform height and widths after resizing
On Aug 21, 11:11 am, melissa wrote:
I have added max and min buttons on my userforms and I would like to make the next userform the same dimensions as the previous form if it was maximized. Please help! thanks i already have the userforms set up. after completing one form, it sends you to a second form. If the first form was maximized, I would like the next form to automatically have the same height and width as the maximized form. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Matching multiple userform height and widths after resizing
Not sure what parameters you arre looking for. Below code modifes some of
the windows parameters. You can activate one window, read the values, then set 2nd window witth same values. Application Window is the excel window. Active window is the windows inside the Excel window. If you havve more than one workbook open they both may be insdie the same excel window. Sub Macro1() ' ' Macro1 Macro ' Macro recorded 8/22/2007 ' ' Application.WindowState = xlMaximized Application.WindowState = xlNormal Application.Width = 200 Application.Height = 150 ActiveWindow.WindowState = xlMaximized ActiveWindow.WindowState = xlNormal ActiveWindow.Width = 600 ActiveWindow.Height = 400 End Sub "Melissa" wrote: On Aug 21, 11:11 am, melissa wrote: I have added max and min buttons on my userforms and I would like to make the next userform the same dimensions as the previous form if it was maximized. Please help! thanks i already have the userforms set up. after completing one form, it sends you to a second form. If the first form was maximized, I would like the next form to automatically have the same height and width as the maximized form. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I stop Excel from automatically resizing my row height? | Excel Worksheet Functions | |||
| auto adjust column widths and row height | Excel Discussion (Misc queries) | |||
| Resizing row height to dynamically fit height of text box | Excel Discussion (Misc queries) | |||
| resizing row height automatically? | Excel Discussion (Misc queries) | |||
| default row height and column widths | New Users to Excel | |||
Hybrid Mode
