| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Align the form to the top left
How to align the form to the top left? Right now when the form is
initialized, it is centrally aligned. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Align the form to the top left
Set the startup position in the initialize event.
Private Sub UserForm_Initialize() UserForm1.StartUpPosition = 3 End Sub -- HTH... Jim Thomlinson "Scott" wrote: How to align the form to the top left? Right now when the form is initialized, it is centrally aligned. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Align the form to the top left
I should have mentioned my use of 3. In VB (not VBA) there are constants for
the start up position. Here they are vbStartUpManual 0 No initial setting specified. vbStartUpOwner 1 Center on the item to which the UserForm belongs. vbStartUpScreen 2 Center on the whole screen. vbStartUpWindowsDefault 3 Position in upper-left corner of screen. VBA does not have the same constants but you can declare them if you wish... I just used 3... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: Set the startup position in the initialize event. Private Sub UserForm_Initialize() UserForm1.StartUpPosition = 3 End Sub -- HTH... Jim Thomlinson "Scott" wrote: How to align the form to the top left? Right now when the form is initialized, it is centrally aligned. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Align the form to the top left
Thanks. It works.
I've also found that I can select "3 - Windows Default" under "StartUpPosition" on "Properties" of the form. "Jim Thomlinson" wrote: I should have mentioned my use of 3. In VB (not VBA) there are constants for the start up position. Here they are vbStartUpManual 0 No initial setting specified. vbStartUpOwner 1 Center on the item to which the UserForm belongs. vbStartUpScreen 2 Center on the whole screen. vbStartUpWindowsDefault 3 Position in upper-left corner of screen. VBA does not have the same constants but you can declare them if you wish... I just used 3... -- HTH... Jim Thomlinson "Jim Thomlinson" wrote: Set the startup position in the initialize event. Private Sub UserForm_Initialize() UserForm1.StartUpPosition = 3 End Sub -- HTH... Jim Thomlinson "Scott" wrote: How to align the form to the top left? Right now when the form is initialized, it is centrally aligned. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Align the form to the top left
Private Sub UserForm_Initialize() Me.StartUpPosition = 0 Me.Left = 0 Me.Top = 0 End Sub -- Hope that helps. Vergel Adriano "Scott" wrote: How to align the form to the top left? Right now when the form is initialized, it is centrally aligned. |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Align the form to the top left
Thanks, it works.
"Vergel Adriano" wrote: Private Sub UserForm_Initialize() Me.StartUpPosition = 0 Me.Left = 0 Me.Top = 0 End Sub -- Hope that helps. Vergel Adriano "Scott" wrote: How to align the form to the top left? Right now when the form is initialized, it is centrally aligned. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Align Left and Right in Same Cell | Excel Discussion (Misc queries) | |||
| Align to the left or to the right (or center) | Excel Programming | |||
| PivotTable: how to align row data to the left? | Excel Programming | |||
| Left align '$' and right align numbers? | Excel Discussion (Misc queries) | |||
| Merge & align ..left? | Excel Programming | |||
Hybrid Mode
