| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Setting Top and Left of Modal UserForm
Many thanks Peter. That made my day!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Userform modal | Excel Discussion (Misc queries) | |||
| Application.OnTime interrupting Modal UserForm | Excel Programming | |||
| Modal Userform and Preview on Screen | Excel Programming | |||
| GetOpenFileName called from modal userform.. enables workbook windows. BUG? | Excel Programming | |||
| Excel97 Userform to be system modal/equivalent | Excel Programming | |||
![Bart[_6_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
