ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MSForm 1 - Initial placement of form (https://www.excelbanter.com/excel-programming/312155-msform-1-initial-placement-form.html)

Tim Coddington

MSForm 1 - Initial placement of form
 
After I load a form, I can set .left or .top when an event occurs such as a
command button click. But how do you make the form come up initially in a
position that is not at the center of the screen? I've tried it in
form.initialize, but that seems to get ignored.



kkknie[_191_]

MSForm 1 - Initial placement of form
 

Put it in the _Activate event procedure.



--
kkkni
-----------------------------------------------------------------------
kkknie's Profile: http://www.excelforum.com/member.php...nfo&userid=754
View this thread: http://www.excelforum.com/showthread.php?threadid=26545


Tim Coddington

MSForm 1 - Initial placement of form - Many thanks.
 

"kkknie" wrote in message
...

Put it in the _Activate event procedure.

K


--
kkknie
------------------------------------------------------------------------
kkknie's Profile:

http://www.excelforum.com/member.php...fo&userid=7543
View this thread: http://www.excelforum.com/showthread...hreadid=265455





All times are GMT +1. The time now is 04:19 PM.

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