Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
You are welcome.
Ken |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Default User Defined Functions - How? | Excel Discussion (Misc queries) | |||
Forms that are modal in 97 are not modal in 2003 | Excel Discussion (Misc queries) | |||
Excel user management | Excel Discussion (Misc queries) | |||
New user in need of assistance excel pop-ups, forms, +more!! | New Users to Excel | |||
find and match the max | Excel Worksheet Functions |