minimize form

[drewdaman]

Hello,

This is probably a nice simple question for most people who have experience with excel/vba.. how can i add a minimize button to a user form? i looked at all the properties and didn't find anything appropriate..

thanks!

 

[ZmrAbdulla]

http://www.ozgrid.com/VBA/minimize-maximize.htm

________________________________________________________________________
Zameer Abdulla
Visit Me
A person who misses a chance and the monkey who misses its branch can't be saved.

 

[rmikesmith]

To incorporate a true Min/Max Window button you must change the attributes of the Userform window using the Win32 API. Stephen Bullen has an Excel demo file (FormFun.xls) on his website. Url:

http://www.oaltd.co.uk/Excel/Default.htm

Regards,
Mike

 

[drewdaman]

thanks for your replies..

trust MS to make it hard to add something as simple as a minimize button!

Zameer, i saw that on the web.. but was hoping there was a better way.. to add true min/max buttons..

mike, yours adds nice buttons, but its too complicated for me! i'm a c++ person.. so i'm ok with classes and OO and stuff.. but i don't wnat to sit and learn OO techniques in vb just to add a silly button ... so i went with the toggle button approach..

thanks for your help guys.

 

[rmikesmith]

drewdaman,

What do you mean?!! I thought you C guys lived and breathed the Win API. That being said, all you need to do is borrow the code Bullen has already written. I've parsed out the bits I needed before so I know you can handle it.

Regards,
Mike

 

[drewdaman]

lol...
i'm lazy and have a deadline for this.. in about 20 mins actually! lol.. that's why!