B
baobob
I've dropped a button on a UserForm. The UserForm is user-resizeable
(thanks to Bullen's FunForm.)
What height property or other vertical quantity do I access in order
to programmatically position the button flush against the bottom of
the form? I want to re-bottom-justify the button in UserForm_Resize
(hope that's the correct event).
I've tried:
1) UserForm.Height seems to be useless, because it seems to include
the form's caption area. So if I say:
Button1.Top = UserForm.Height - Button1.Height
then the button's too low by approx. UserForm's caption.
2) Application.UseableHeight sounds promising, but on one Win 2K PC it
seems to return Excel's own (or possibly the open workbook's) useable
height, which is, like 100 pixels (points?) larger than
UserForm.Height.
(BUT, on another Win 2K PC with a different screen res., the button
ends up aligning PERFECTLY, no matter how the user resizes the form.
Don't quite understand THAT coincidence.)
3) UserForm has no UseableHeight property that I can see.
I suppose another way of asking this is: Is there a way to determine
the height of an application's caption area?
Thanks much.
***
(thanks to Bullen's FunForm.)
What height property or other vertical quantity do I access in order
to programmatically position the button flush against the bottom of
the form? I want to re-bottom-justify the button in UserForm_Resize
(hope that's the correct event).
I've tried:
1) UserForm.Height seems to be useless, because it seems to include
the form's caption area. So if I say:
Button1.Top = UserForm.Height - Button1.Height
then the button's too low by approx. UserForm's caption.
2) Application.UseableHeight sounds promising, but on one Win 2K PC it
seems to return Excel's own (or possibly the open workbook's) useable
height, which is, like 100 pixels (points?) larger than
UserForm.Height.
(BUT, on another Win 2K PC with a different screen res., the button
ends up aligning PERFECTLY, no matter how the user resizes the form.
Don't quite understand THAT coincidence.)
3) UserForm has no UseableHeight property that I can see.
I suppose another way of asking this is: Is there a way to determine
the height of an application's caption area?
Thanks much.
***