Results 1 to 3 of 3

Thread: [RESOLVED] Full screen userform

  1. Jul 3rd, 2007, 04:22 PM #1
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Resolved [RESOLVED] Full screen userform

    Is it possible to maximize a UserForm in Excel or to display in full screen?
    Last edited by Fonty; Jul 3rd, 2007 at 04:46 PM.
    Reply With Quote Reply With Quote
  2. Jul 3rd, 2007, 04:29 PM #2
    zaza
    zaza is offline
    Frenzied Member zaza's Avatar
    Join Date
    Apr 2001
    Location
    Borneo Rainforest Habits: Scratching
    Posts
    1,486

    Re: Full screen userform

    A cheat's way off the top of my head:

    VB Code:
    1. Application.DisplayFullScreen = True

    2. UserForm1.Width = Application.ActiveWindow.Width

    3. UserForm1.Height = Application.ActiveWindow.Height

    4. UserForm1.Move 0, 0

    5. Application.DisplayFullScreen = False

    zaza
    I use VB 6, VB.Net 2003 and Office 2010



    Code:
    Excel Graphing | Excel Timer | Excel Tips and Tricks | Add controls in Office | Data tables in Excel | Gaussian random number distribution (VB6/VBA,VB.Net) | Coordinates, Vectors and 3D volumes
    Reply With Quote Reply With Quote
  3. Jul 3rd, 2007, 04:46 PM #3
    Fonty
    Fonty is offline

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Re: Full screen userform

    Great!
    Thanks a lot
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width