View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ardus Petus Ardus Petus is offline
external usenet poster
 
Posts: 718
Default Placing buttons etc on userform

Try:
CommandButton1.Top = Me.top + Me.Height - 20

HTH
--
AP

"Gert-Jan" a écrit dans le message de news:
...
With this macro I set my userform to maximum screensinze.

Sub UserForm_Initialize()
With Application
Me.Top = .Top
Me.Left = .Left
Me.Height = .Height
Me.Width = .Width
End With
End Sub

In the footer of the userform I would like to place some bittons / remarks
and tried this code:

Private Sub UserForm_Activate()
CommandButton1.Top = UserForm1.Height - 20
End Sub

But, this will not work. Someone have an idea?

Gert-Jan