Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Provide ability to resize form when open
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Provide ability to resize form when open
Andy Pope has some very nice code here... http://www.andypope.info/vba/resizeform.htm -- Jim Cone Portland, Oregon USA "Jonathan Brown" 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Provide ability to resize form when open
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. "Jim Cone" wrote: Andy Pope has some very nice code here... http://www.andypope.info/vba/resizeform.htm -- Jim Cone Portland, Oregon USA "Jonathan Brown" 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to open xml in a excel using xslt? provide an example. | Excel Discussion (Misc queries) | |||
I have lost ability to open xls spreadsheets sent in emails | Excel Discussion (Misc queries) | |||
Validations: provide the ability to format the fonts in the list | Excel Worksheet Functions | |||
provide ability to undo a save - saved by mistake | Excel Worksheet Functions | |||
lost double click ability to open files | Excel Programming |