+ Reply to Thread
Results 1 to 7 of 7

Load Userform in Maximize positions or size

  1. #1
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Load Userform in Maximize positions or size

    Hi Experts

    The following code works excellent to Add Minimize and Maximize Button in Userform
    In Module
    Please Login or Register  to view this content.
    In UserForm Code
    Please Login or Register  to view this content.
    Now I just want to know. Is this possible when I load userform then it should be open in maximize mode.
    Means It should automatically open fullscreen or maximize mode.

    Please guide me

    I shall be very thankful to you
    Attached Files Attached Files
    Last edited by AmirSoft; 11-28-2017 at 08:22 AM.
    Don't wait for the PERFECT MOMENT
    take the moment and make it PERFECT
    Amir

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Load Userform in Maximize positions or size

    Hi,

    Add the following to the userform module at the top
    Please Login or Register  to view this content.
    then you need to modify the Activate event code to
    Please Login or Register  to view this content.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  3. #3
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Re: Load Userform in Maximize positions or size

    Thank you so much xlnitwit
    You are genius.

  4. #4
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Re: Load Userform in Maximize positions or size

    xlnitwit

    How can I minimize this form in Excel Icon in Taskbar

    Please guide me.

  5. #5
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Load Userform in Maximize positions or size

    You already have a minimize button on the form.

  6. #6
    Forum Contributor
    Join Date
    09-18-2014
    Location
    Pakistan
    MS-Off Ver
    2013, 2016
    Posts
    283

    Re: Load Userform in Maximize positions or size

    Yes I have
    But it minimize the userform in left bottom of screen.
    I want this should minimize the userform in Task Bar. Where Excel Icon is displayed in the bar.

  7. #7
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Load Userform in Maximize positions or size

    Here is the code I use for that. I have commented out the code I use to add an icon to the form.
    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Minimize, Maximize in userform
    By mido21 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-27-2017, 10:25 AM
  2. Weird issue with VBA IDE - all module windows maximize/restore size
    By PegLegPete in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2015, 05:20 PM
  3. [SOLVED] Maximize programs called from Userform
    By smooth_beaker in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-09-2014, 11:33 AM
  4. Add Maximize button to userform
    By Mamud in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-04-2014, 08:39 AM
  5. [SOLVED] Macro to sum selected cells into a new row - size and positions ARE RELATIVE
    By macropulos in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-06-2013, 03:46 PM
  6. Maximize and Minimize the Userform
    By yeshwant_sur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2012, 06:27 AM
  7. How to Maximize Print Size
    By John Michl in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-27-2005, 12:05 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1