Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Excel VBA > Excel VBA
|
Excel VBA Discuss using VBA for Excel programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Excel VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old December 2nd, 2004, 07:11 PM
kev kev is offline
Registered User
 
Join Date: Dec 2004
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default userform minimise & maximise buttons

How can I add minimise & maximise buttons to a userform?
Thanks in advance
 
Old December 7th, 2004, 04:45 PM
Authorized User
 
Join Date: Jul 2004
Posts: 10
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Dear Kev,

Min en Max buttons at the right top near the little x are not so easy to programm.

I suppose you only want to hide en show the userform.
Let assume that your userform has the name frmKevsForm.

Place a button on frmKevsForm and add this simple routine on it :

Public sub CommandButton1_Click
frmKevsForm.Hide
End sub

If you want to show your frmKevsForm then you heve to place a button
on another place or form or even in a subroutine
Suppose you activate it with a button then the code is :

Public sub cdmShowKevsForm
frmKevsForm.Show 0 ' this is a Zero not a letter O
End sub

The Zero is optional but if you add it then you can do other tasks while
your Userform frmKevsForm is showed.
If you don't add the zero then your userform is Modal and in that case you have
to close the frmKevsForm ( with the litlle x on top) before you can do
anything else outside the form.

I hope your satisfied with my answer.
If not, try the site www.exceltips.com for instance.






Similar Threads
Thread Thread Starter Forum Replies Last Post
minimise a <div> (adjust height) crmpicco Javascript How-To 1 September 21st, 2005 01:39 AM
Linux & KDE & C++ & QT & MYSQL & Kdevelop Munnnki Linux 0 January 2nd, 2005 05:41 PM
Remove UserForm lostthought VB How-To 0 July 29th, 2004 12:46 PM
Using icons within a userform Stubby Excel VBA 2 July 7th, 2004 08:09 AM
Surface in a userform Rosser VB How-To 0 March 31st, 2004 06:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.