![]() |
Positioning 2 User Forms
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 |
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 |
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 "Ken Macksey" wrote: 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 |
You are welcome.
Ken |
All times are GMT +1. The time now is 04:07 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com