Provide ability to resize form when open

  • Thread starter Thread starter Jonathan Brown
  • Start date Start date
J

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.
 
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.
 
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.
 
Back
Top