| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
userform fullscreen
Hi experts,
I would like to have my userform fullscreen so that the screen resolution does not matter anymore.. oes somebody have the code for that ? Thanks, Pierre -- Message posted via http://www.officekb.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform fullscreen
With UserForm1
.Top = 1 .Left = 1 .Height = Application.UsableHeight .Width = Application.UsableWidth End With -- Ian -- "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:56cd3877cd85f@uwe... Hi experts, I would like to have my userform fullscreen so that the screen resolution does not matter anymore.. oes somebody have the code for that ? Thanks, Pierre -- Message posted via http://www.officekb.com |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform fullscreen
This uses the usable area, but if you want to cover the whole Excel app,
then use Application.WindowState = xlMaximized With Application Me.Top = .Top Me.Left = .Left Me.Height = .Height Me.Width = .Width End With If you want true maximize like a standard app, you need APIs. -- HTH RP (remove nothere from the email address if mailing direct) "Ian" wrote in message ... With UserForm1 .Top = 1 .Left = 1 .Height = Application.UsableHeight .Width = Application.UsableWidth End With -- Ian -- "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:56cd3877cd85f@uwe... Hi experts, I would like to have my userform fullscreen so that the screen resolution does not matter anymore.. oes somebody have the code for that ? Thanks, Pierre -- Message posted via http://www.officekb.com |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform fullscreen
Hi Ian,
Do you also know how to get a multipage centered on a userform ? thanks man ! Pierre Ian wrote: With UserForm1 .Top = 1 .Left = 1 .Height = Application.UsableHeight .Width = Application.UsableWidth End With Hi experts, [quoted text clipped - 3 lines] Thanks, Pierre -- Message posted via http://www.officekb.com |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
userform fullscreen
See other thread
-- HTH RP (remove nothere from the email address if mailing direct) "Pierre via OfficeKB.com" <u13950@uwe wrote in message news:56d97708921a7@uwe... Hi Ian, Do you also know how to get a multipage centered on a userform ? thanks man ! Pierre Ian wrote: With UserForm1 .Top = 1 .Left = 1 .Height = Application.UsableHeight .Width = Application.UsableWidth End With Hi experts, [quoted text clipped - 3 lines] Thanks, Pierre -- Message posted via http://www.officekb.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| useform autosize to fullscreen problem | Excel Worksheet Functions | |||
| deactivate fullscreen | Excel Programming | |||
| FullScreen Question | Excel Programming | |||
| Fullscreen | Excel Programming | |||
| Display a range fullscreen | Excel Programming | |||
![Pierre via OfficeKB.com[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
