Minimise form. leave open in background etc.

[RITCHI]

Hi

I have a user form which has been set up to be used as a menu with lots
of buttons doing various operations.
After clicking a button and carrying out the task(s) I would like to
able to move back into a worksheet(s) do some work and then step back
to the form.

At present I have to close the form do the work and then reopen it.

Is it possible to minimise the form, leave it open in the background
whilst I work on the sheets and then maximise to choose/use further
menu items etc.?

Any help with coding would be gratefully received.


Thanks

Richi

 

[Earl Kiosterud]

Richi,

You can make the userform modeless. In the properties for the form, set
ShowModal property to False. I think this started with Excel 2000.