Results 1 to 12 of 12
  1. #1
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding Minimize Button to Userform

    Any ideas on how to do this?

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Adding Minimize Button to Userform

    Hi Drk - me again!
    Sadly I don't believe that you can do this - in Office 97 all userforms are modal - you have to hide or Unload them before you can use any other part of your application. Even in 2000, I haven't found a way to minimize them so I can't even suggest an upgrade[img]/w3timages/icons/wink.gif[/img]
    If anyone can show me I'm wrong, I'll be very happy to hear it though![img]/w3timages/icons/grin.gif[/img]
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Minimize Button to Userform

    Bummerrrr....

    Please say he's wrong folks!!!

    Thanks again Rory!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Adding Minimize Button to Userform

    You could go for two simple macros to show/hide it with shortcut keys assigned to each (or a toolbar)?
    i.e. something like frmtracker.show and frmtracker.hide
    Any good?
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Minimize Button to Userform

    Okay, if I can't add a standard minimize button, I know I can hide the form, can I minimize excel from VBA on btnminimize_click?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  6. #6
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Minimize Button to Userform

    Hmm... there's an idea...

    You think it can be done in one fowl swoop? (These users are very ease oriented...) I.E. Button click, form hides, application minimizes. On Maximize, form show?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  7. #7
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Adding Minimize Button to Userform

    Application.windowstate = xlMinimized should work.
    Regards,
    Rory

    Microsoft MVP - Excel

  8. #8
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Minimize Button to Userform

    I was just going to say that, but:

    sub btnmini_click()
    frmtracking.hide
    Application.WindowState = xlMinimized
    End Sub

    The code closes out the form, doesn't 'Hide' it per-say... can you think of a way to start where the user left off? if you need me to provide the app I can..
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  9. #9
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Adding Minimize Button to Userform

    I guess with another Public variable which is set to true by clicking the minimize button, then in the Activate event of the workbook, check the variable, if true, show the form. Not sure off the top of my head if you'd lose any data in the form.
    I'll get back to you tomorrow.
    Regards,
    Rory

    Microsoft MVP - Excel

  10. #10
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Minimize Button to Userform

    The data is based on the worksheet... I have an on-form counter which does not tie to the worksheet, but is based on a variable "i" (which is the same as the row-source)... perhaps I can tie the show command into that to simulate a refresh to where they were... I'll let you know..

    Thanks!
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  11. #11
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Minimize Button to Userform

    Here's the route i'm taking... what do you think?
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

  12. #12
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Northern, California, USA
    Posts
    1,886
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding Minimize Button to Userform

    Come on!! there's no way to 'minimize' a form!?!?!

    -I curse Microsoft Daily.
    <IMG SRC=http://www.wopr.com/w3tuserpics/Kel_sig.gif>
    Moderator:<font color=448800> Pix Place, Internet Explorer</font color=448800>
    <small>www.kvisions.com

Posting Permissions

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