VBA - Minimize/maximize a UserForm

Ask a question
This demo allows you to resize a UserForm, using the system buttons or the arrow keys.
This demo includes:
  • A minimize system button
  • A maximize system button
  • A restore button
  • Resizing the userform with arrow keys.
  • Automatic adjustment of the size of the components of the Userform (Zoom)

Download the demo workbook:
Maximizer Minimizer UF V2.xlsm
Compatibility: As from Excel 2007.
Jean-François Pillou

CCM is a leading international tech website. Our content is written in collaboration with IT experts, under the direction of Jeff Pillou, founder of CCM.net. CCM reaches more than 50 million unique visitors per month and is available in 11 languages.

Learn more about the CCM team