hello all;
I need to add maximize button to enlarge my form ?
file is here
http://www.andypope.info/vba/Anchor.htm
hello all;
I need to add maximize button to enlarge my form ?
file is here
http://www.andypope.info/vba/Anchor.htm
That isn't a link to a file.
If posting code please use code tags, see here.
Her's the link
http://www.andypope.info/vba/AnchorControls.zip
Don't you have a link to your own file?
Book2.xlshere's the file
Last edited by Mamud; 12-31-2013 at 03:07 AM.
hello , any help please
see the FormFun example on Stepehn Bullen's site
http://www.oaltd.co.uk/Excel/Default.htm
Andy, I tried more than time to get that example applicable on mine, but i failed
please can you explain that in my form
really i can't
As you did not post what you had tried so we could see the problem I just added the code to your file
Hi andy, what i tried is to enlarge controls in userform with maximize but i failed in that
I have more than one userform contains different controls with different dimensions, so I need to understand the technique of the "FormFun" to use it in my forms, the attached form is an example
You don't need the anchor control example for that you can simply change the zoom.
See attached
Andy, I think zoom makes the userform controls so big
can I do that with "FormFun" example?
The formfun code adds the Maximize button to the caption bar of the userform. That's it.
Once the userform is maximized you would need to resize and reposition all the controls. The Zoom would do that, but you don't like the size used.
The anchor control will automatically position or size controls. I don't think it will do what you want which is to size a little and move a bit.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks