Provide ability to resize form when open

[Jonathan Brown]

This has got to be an easy thing to do. I've got a floating userform that
I'm using to help the user interact with the workbook. I can't for the life
of me figure out how to set the border style to sizeable. In other words,
allow the user to resize the form by draging the form edges. I'm using the
formname.show vbmodeless code to open the form. even if I take out the
vbModeless option I still can't resize the form. Any help would be
appreciated.

 

[Jim Cone]

Andy Pope has some very nice code here...
http://www.andypope.info/vba/resizeform.htm
--
Jim Cone
Portland, Oregon USA



"Jonathan Brown"
<[email protected]>
wrote in message
This has got to be an easy thing to do. I've got a floating userform that
I'm using to help the user interact with the workbook. I can't for the life
of me figure out how to set the border style to sizeable. In other words,
allow the user to resize the form by draging the form edges. I'm using the
formname.show vbmodeless code to open the form. even if I take out the
vbModeless option I still can't resize the form. Any help would be
appreciated.

 

[Jonathan Brown]

That is fantastic. I guess it's not as easy as I was think it would be. The
code that you referred me to worked wonders. Thank you.