Consulting

Results 1 to 5 of 5

Thread: fullscreen userform

  1. #1

    Question fullscreen userform

    Hi all friends
    I am a User Form and ask when it opens in full screen
    I am grateful for your guidance.

    Book1.xlsm

  2. #2
    VBAX Expert
    Joined
    Oct 2012
    Posts
    726
    Location
    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

  3. #3
    And controls fullscreen alow

  4. #4
    Tried using TrevorG code:
    Private Sub UserForm_Initialize()
    With Application
    .WindowState = xlMaximized
    Me.Top = .Top
    Me.Left = .Left
    Me.Height = .Height
    Me.Width = .Width
    End With
    End Sub
    Keep getting message that use of ME is illegal
    Any thoughts?

    dinosaur game
    Last edited by Aussiebear; 11-23-2022 at 10:43 PM. Reason: Added code tags to supplied code

  5. #5
    Moderator VBAX Sage SamT's Avatar
    Joined
    Oct 2006
    Location
    Near Columbia
    Posts
    7,814
    Location
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •