How Do I Resize A Userform In Excel 2011 For Mac

Posted on by

How

How Do I Resize A Userform In Excel 2011 For Mac Shortcut

Shortcut

There may be other reasons your userform will not work as expected on the Mac. Userforms which are properly sized in Windows will appear very small on the Mac. There are ways to get around this, once the userform successfully appears on the Mac in any size. You can use 'ActiveWindow.Height' or 'Application.Height' to determine the maximum visible UserForm height. If the UserForm is larger than the 'maximum visible height', you can add ScrollBars to the UserForm. See the attached file which includes UserForm MouseWheel code (32 bit Excel only) at no extra charge. As I open a UserForm, I want to maximize the size of the form (making it as large as my monitor). In the VB6 Form property, there is a property called 'WindowState' and I can select 'Maximized.' But, I can't find a similar property in Excel VBA. How can I automatically maximize a UserForm in Excel VBA? Thank you Takashi Yamauchi. To create a new UserForm 1. Open the Excel workbook and go to VBA (ALT + F11). Under VBA, click the 'Insert UserForm' button. Click Toolbox button. Use controls on the form by clicking the appropriate button on the toolbox. To edit the properties of a control, use the Properties window. To remove a control, select and press the.

How Do I Resize A Userform In Excel 2011 For Macs

Resize
January 16th 08, 02:39 AMposted to microsoft.public.excel.programming
external usenet poster
Posts: 3,986
maximizing the size of a UserForm
I just created a UserForm for a test. I put the width and height dimensions
in the initialize event like this:
Private Sub UserForm_Initialize()
With UserForm1
.Width = 640
.Height = 480
End With
End Sub
Then in the VBA module I use:
Sub UFtst()
UserForm1.Show(Modal)
MsgBox 'Check Size'
Unload UserForm1
End Sub
It brings the form up in the larger dimension, which indicates that you can
set it to
fit your full screen size.
'Takashi Yamauchi' wrote:

Could anyone give me a suggestion?
As I open a UserForm, I want to maximize the size of the form (making it as
large as my monitor). In the VB6 Form property, there is a property called
'WindowState' and I can select 'Maximized.' But, I can't find a similar
property in Excel VBA. How can I automatically maximize a UserForm in Excel
VBA?
Thank you
Takashi Yamauchi