Positioning 2 User Forms

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

mully - 10 Jun 2005 18:08 GMT

Hi

I hope I explain this correctly - I have user form 1 which on opening fills
the monitor screen with everything in its correct place and working OK.
Within the same Workbook I have a small user form 2 which is opened by a
command button on user form 1. On opening that works perfectly OK. However no
matter what I try and do and that includes changing Start Up Position = in
the VBA the damn thing always opens in the middle of user form 1 - when the
desired position would be in an empty space available on the baseline of user
form1.

Any help and suggestions would be much appreciated

Cheers ----- Mully

Reply to this Message

Ken Macksey - 10 Jun 2005 20:01 GMT

Try setting userform2's startuppos property to manual and userform2's left
and top properties to whatever you need them to be, something like left =
350 and top = 150. It seemed to work for me.

HTH

Ken

Reply to this Message

mully - 10 Jun 2005 20:34 GMT

Hi Ken

Thanks very much - worked perfectly - got it just where its needed to be -
able to see both forms clearly - Never thought about setting to manual -
old age and Alzhiemers setting in - Once again thank you for your help.

Cheers ------ Mully

> Try setting userform2's startuppos property to manual and userform2's left
> and top properties to whatever you need them to be, something like left =
[quoted text clipped - 3 lines]
>
> Ken

Reply to this Message

Ken Macksey - 11 Jun 2005 20:15 GMT

You are welcome.

Ken

Reply to this Message