User Forms

R

rmhpirate

New Member
Joined
Aug 31, 2007
Messages
1
I currently have a user form. But I want it to open maximized within the excel application. How do I go about doing this?
 

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
Sort by date Sort by votes
Right click the UserForm > View Code. Paste in

Code: 
Private Sub UserForm_Activate()
    With Application
        Me.Top = .Top
        Me.Left = .Left
        Me.Height = .Height
        Me.Width = .Width
    End With
End Sub
 
Upvote 0
You must log in or register to reply here.

Similar threads

BartH
  • Solved
Get properties of userform
Replies
2
Views
369
BartH
BartH
K
  • Question
Password to unhide worksheets
Replies
3
Views
356
Micron
M
T
  • Question
Form view available directly on opening workbook.
Replies
1
Views
182
Micron
M
C
  • Question
Custom Ribbon Strange Behaviour in Shared Workbook Saved in Maximized Window Mode
Replies
0
Views
326
coolvi
C
S
  • Solved
This Workbook event code for Workbook_WindowResize
2 3
Replies
29
Views
1K
sspatriots
S

Forum statistics

Threads
1,214,529
Messages
6,120,070
Members
448,943
Latest member
sharmarick

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top