+ Reply to Thread
Results 1 to 9 of 9

Minimize, Maximize in userform

  1. #1
    Registered User
    Join Date
    11-28-2010
    Location
    egypt
    MS-Off Ver
    Excel 2016
    Posts
    43

    Minimize, Maximize in userform

    hi all
    I want the appearance of the key to Minimize, Maximize in userform
    Minimize key Minimises the above taskbar

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229

    Re: Minimize, Maximize in userform

    Perhaps this is what you are looking for.
    Attached Files Attached Files
    _
    ...How to Cross-post politely...
    ..Wrap code by selecting the code and clicking the # or read this. Thank you.

  3. #3
    Registered User
    Join Date
    11-28-2010
    Location
    egypt
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Minimize, Maximize in userform

    welcome mikerickson
    thank you very much for your response and help Me
    Benefited a lot of code listed to work

  4. #4
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Minimize, Maximize in userform

    Try this one
    code for module
    Please Login or Register  to view this content.
    and this one add to Userform

    Please Login or Register  to view this content.
    Use Code-Tags for showing your code :
    Please mark your question Solved if there has been offered a solution that works fine for you
    If You like solutions provided by anyone, feel free to add reputation using STAR *

  5. #5
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Minimize, Maximize in userform

    For
    for 32 bit version
    remove PtrSafe From Private Function
    Please Login or Register  to view this content.

  6. #6
    Registered User
    Join Date
    11-28-2010
    Location
    egypt
    MS-Off Ver
    Excel 2016
    Posts
    43

    Re: Minimize, Maximize in userform

    Thank you HaroonSid
    All right, that's it
    is it possible to preserve the Zoom
    In other words,
    consistent with size of user form and controls

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Minimize, Maximize in userform

    Try this sample
    Please Login or Register  to view this content.
    Attached Files Attached Files
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  8. #8
    Registered User
    Join Date
    10-19-2017
    Location
    Houston, TX, USA
    MS-Off Ver
    2016
    Posts
    9

    Re: Minimize, Maximize in userform

    Haroon,

    This is very helpful. It works perfectly and still restores the form back to its original size.

    Regards,

  9. #9
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Re: Minimize, Maximize in userform

    Welcome AJalal

+ 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. How to add a Minimize/Maximize Button to a autorun UserForm
    By cshm in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-04-2013, 01:11 PM
  2. Maximize and Minimize the Userform
    By yeshwant_sur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2012, 06:27 AM
  3. Replies: 4
    Last Post: 09-06-2005, 06:05 AM
  4. Replies: 0
    Last Post: 09-06-2005, 12:05 AM
  5. Replies: 0
    Last Post: 09-05-2005, 11:05 PM
  6. Replies: 0
    Last Post: 09-05-2005, 10:05 PM
  7. Replies: 1
    Last Post: 07-08-2005, 11:05 PM
  8. Replies: 2
    Last Post: 07-08-2005, 11: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