Hi all friends
I am a User Form and ask when it opens in full screen
I am grateful for your guidance.
Book1.xlsm
Hi all friends
I am a User Form and ask when it opens in full screen
I am grateful for your guidance.
Book1.xlsm
Dim xlws As XlWindowState xlws = Application.WindowState Application.WindowState = xlMaximized With UserForm1 .Top = Application.Top .Left = Application.Left .Width = Application.Width .Height = Application.Height .Show End With Application.WindowState = xlws
And controls fullscreen alow
Tried using TrevorG code:
Keep getting message that use of ME is illegalPrivate Sub UserForm_Initialize() With Application .WindowState = xlMaximized Me.Top = .Top Me.Left = .Left Me.Height = .Height Me.Width = .Width End With End Sub
Any thoughts?
dinosaur game
Last edited by Aussiebear; 11-23-2022 at 10:43 PM. Reason: Added code tags to supplied code
Use jonh's Code
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ