+ Reply to Thread
Results 1 to 13 of 13

Add Maximize button to userform

  1. #1
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Add Maximize button to userform

    hello all;

    I need to add maximize button to enlarge my form ?

    file is here

    http://www.andypope.info/vba/Anchor.htm

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Add Maximize button to userform

    That isn't a link to a file.
    If posting code please use code tags, see here.

  3. #3
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Add Maximize button to userform

    Her's the link

    http://www.andypope.info/vba/AnchorControls.zip

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Add Maximize button to userform

    Don't you have a link to your own file?

  5. #5
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Add Maximize button to userform

    Book2.xlshere's the file
    Last edited by Mamud; 12-31-2013 at 03:07 AM.

  6. #6
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Add Maximize button to userform

    hello , any help please

  7. #7
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Add Maximize button to userform

    see the FormFun example on Stepehn Bullen's site
    http://www.oaltd.co.uk/Excel/Default.htm
    Cheers
    Andy
    www.andypope.info

  8. #8
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Add Maximize button to userform

    Andy, I tried more than time to get that example applicable on mine, but i failed

    please can you explain that in my form

    really i can't

  9. #9
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Add Maximize button to userform

    As you did not post what you had tried so we could see the problem I just added the code to your file
    Attached Files Attached Files

  10. #10
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Add Maximize button to userform

    Hi andy, what i tried is to enlarge controls in userform with maximize but i failed in that

    I have more than one userform contains different controls with different dimensions, so I need to understand the technique of the "FormFun" to use it in my forms, the attached form is an example

  11. #11
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Add Maximize button to userform

    You don't need the anchor control example for that you can simply change the zoom.

    See attached
    Attached Files Attached Files

  12. #12
    Forum Contributor
    Join Date
    09-01-2011
    Location
    England
    MS-Off Ver
    Excel 365
    Posts
    126

    Re: Add Maximize button to userform

    Andy, I think zoom makes the userform controls so big

    can I do that with "FormFun" example?

  13. #13
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Add Maximize button to userform

    The formfun code adds the Maximize button to the caption bar of the userform. That's it.

    Once the userform is maximized you would need to resize and reposition all the controls. The Zoom would do that, but you don't like the size used.
    The anchor control will automatically position or size controls. I don't think it will do what you want which is to size a little and move a bit.

+ 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. Maximize Userform on Workbook Active
    By savio21 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2011, 11:01 AM
  4. maximize open excel button from desktop
    By dariarn in forum Excel General
    Replies: 0
    Last Post: 11-15-2011, 01:17 PM
  5. How to show the maximize button
    By L. A. M. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-13-2005, 10:05 AM

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