ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Setting Top and Left of Modal UserForm (https://www.excelbanter.com/excel-programming/393215-setting-top-left-modal-userform.html)

Bart[_6_]

Setting Top and Left of Modal UserForm
 
Dear All,

From the Modul-Level of one UserForm I'm trying to set the .Top and

the .Left of another UserForm. Both are Modal. Somehow this doesn't
seem to work. I can set .Height and .Width in this manner.

Does anybody knows why?

Regards,

Bart


Bart[_6_]

Setting Top and Left of Modal UserForm
 
I forgot to mention: there isn't any Error Message. The UserForm stays
in the middle of the screen.

Bart


Peter T

Setting Top and Left of Modal UserForm
 
Hi Bart,

Change the form's StartUpPosition property to Manual, can do that at design
time or in runtime

Regards,
Peter T

"Bart" wrote in message
ups.com...
Dear All,

From the Modul-Level of one UserForm I'm trying to set the .Top and

the .Left of another UserForm. Both are Modal. Somehow this doesn't
seem to work. I can set .Height and .Width in this manner.

Does anybody knows why?

Regards,

Bart




Bart[_6_]

Setting Top and Left of Modal UserForm
 
Many thanks Peter. That made my day!



All times are GMT +1. The time now is 12:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com