minimize userform to windows taskbar

Hi,

I have got a userform that is used on a daily basis. However, when I click "show desktop" the userform disappears. And I have to reopen it by clicking on alt+tab to recall it. Is it possible to create a minimize button on the userform and when you click it the userform should go to the taskbar as all other windows programmes. So you can easily reopen it?

PS: I found a code that adds a minimize button to the userform but it doesn't minimize the form to the windows taskbar next to the other applications. It just minimizes the form separately above the taskbar.

I don't know about minimizing the form, but you could add a button to the spreadsheet that calls the userform. This way you can exit the form when done and just click the button on the spreadsheet when you need it again.

To preform what I described above just go to the DEVELOPERS tab => INSERT then under from controls click the button and place it where you would like it to appear on the screen.

Then add the following code to it

Sub Button1_Click()
'Displays Form
FromName.Show
End Sub