Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
mully
 
Posts: n/a
Default 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
  #2   Report Post  
Ken Macksey
 
Posts: n/a
Default

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   Report Post  
mully
 
Posts: n/a
Default

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   Report Post  
Ken Macksey
 
Posts: n/a
Default

You are welcome.

Ken


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Default User Defined Functions - How? flycast Excel Discussion (Misc queries) 4 May 26th 05 04:26 AM
Forms that are modal in 97 are not modal in 2003 Old Car Excel Discussion (Misc queries) 1 April 27th 05 08:25 AM
Excel user management CTE Excel Discussion (Misc queries) 1 February 22nd 05 12:12 PM
New user in need of assistance excel pop-ups, forms, +more!! Ken Macksey New Users to Excel 4 January 15th 05 03:18 PM
find and match the max buffyslay Excel Worksheet Functions 0 November 2nd 04 01:57 PM


All times are GMT +1. The time now is 02:31 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"