Adding Minimize Button to Userform

Topic

New Reply

Any ideas on how to do this?

Thanks!

Reply | Quote

Replies

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
If anyone can show me I’m wrong, I’ll be very happy to hear it though!

Reply | Quote

Bummerrrr….

Please say he’s wrong folks!!!

Thanks again Rory!

Reply | Quote

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?

Reply | Quote

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?

Reply | Quote

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?

Reply | Quote

Application.windowstate = xlMinimized should work.

Reply | Quote

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..

Reply | Quote

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.

Reply | Quote

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!

Reply | Quote

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

-I curse Microsoft Daily.

Reply | Quote

Here’s the route i’m taking… what do you think?

Reply | Quote