Minimize button on a userform?

Ruffinshot

New Member
Joined
Jul 7, 2002
Messages
32
Is there any way to either a) put a clickable minimize button next to the close button on a userform? OR b) make the top of the userform (the caption) clickable?
 
'If your Form is that cluttered you should think about redesigning it,'

Only one row of buttons is visible at any time. The rest are display windows that open or close depending on what's being done. It's fairly compact, with most of the space being used by sliding displays. So all the clutter just folds up and goes away.

'or assign the code to the UserForm Double Click, or the Click'

The caption bar isn't clickable, and I'd like to be able to minimize it to just the caption bar (or smaller) to prevent anyone from running something on a partial form. So anything that would make the caption bar clickable would solve it.

'or assign it to a shortcut key.'

There's a possibility! How's that work? I thought of a key-press event, but the focus shifts too much.
 
Upvote 0

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,215,493
Messages
6,125,119
Members
449,206
Latest member
burgsrus

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top