Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Maximize Userform

I've created userforms to show\alter spreadsheets everything works not a
problem. But i ran it on a different computer with a lower res and the
userforms went off the side of the screen. Any1 know some sort of
userform maximize code ?? greatfull 4 any help


---
Message posted from http://www.ExcelForum.com/

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default Maximize Userform

Here are some options

1)Design for the lowest resolution you will use

2)Have multiple userforms, one for each resolution

3)have your code move and space all your controls and then size the userform

4) use a scrolling userform

5) look at the zoom property of the userform

--
Regards,
Tom Ogilvy


"Swift2003 " wrote in message
...
I've created userforms to show\alter spreadsheets everything works not a
problem. But i ran it on a different computer with a lower res and the
userforms went off the side of the screen. Any1 know some sort of
userform maximize code ?? greatfull 4 any help


---
Message posted from http://www.ExcelForum.com/



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
maximize window Bill Excel Discussion (Misc queries) 2 October 9th 07 02:43 PM
My worksheets will not maximize. Bdunn Excel Discussion (Misc queries) 0 June 10th 05 03:53 PM
How to maximize workbooks (out of IE) tbk123 Excel Discussion (Misc queries) 3 March 15th 05 01:01 PM
How to get Maximize and Minimize buttons on Userform TBA[_2_] Excel Programming 1 September 9th 03 08:13 PM
Minimize workwook and then maximize UserForm Fede Querio Excel Programming 0 July 28th 03 06:44 PM


All times are GMT +1. The time now is 10:57 PM.

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

About Us

"It's about Microsoft Excel"