No Minimise/Maximise Button of UserForm in Excel 2007

2 replies [Last post]
Thu, 03/11/2010 - 15:51
corona_gigantes
User offline. Last seen 1 year 48 weeks ago. Offline
Joined: 03/11/2010
Posts: 2

Hi,

In Excel 2007 I created a userform in the VB environment.  Yet, in the properties I can find a item where you can turn on the max/min button or even show one.  Does anyone know how these can be turned on?

‹ Macro directed to wrong drive Update Text Fields in PDF document ›
Top
Mon, 03/15/2010 - 05:39
#1
Support
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 06/02/2008
Posts: 15
You have to program that yourself.

Hi,

You have to program that yourself. Have a look here.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=165

A Point that isn't mentioned on the site.

Set the the 'ShowModal' property to false or minimising is a bit of a waste
of time because you can't do anything else in the workbook.

Top
Mon, 03/15/2010 - 05:34
#2
Support
User offline. Last seen 4 weeks 4 days ago. Offline
Joined: 06/02/2008
Posts: 15
No Minimise/Maximise Button of UserForm in Excel 2007

You need to add a control button.  then in the properties window (view
Properties) change the caption of the control button to the text that
you want to apper on the button.  then in the button click function wite
your own code to get the min or max values.

Top