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.
On 2002-07-08 13:14, Mark O'Brien wrote:
Come on Juan, 'fess up, you ripped that from http://www.bmsltd.co.uk. (That's where I got it from as well /board/images/smiles/icon_biggrin.gif)
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.