Vertical & Horizontal Centered Command Button

[Russell_Leaves]

Hi

Is it possible to align a command button within a page so that it is aligned in both the vertical and horizontal positions no matter what the screen resolution of the computer is?

Thanks

 

[Russell_Leaves]

Hi

Tried this.

Sub ShowForm()
Dim CommandButton1 As Object
On Error Resume Next
      CommandButton1.Show False


With CommandButton1
  .StartUpPosition = 0
  .Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
  .Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
  .Show
End With


End Sub

But it doesn't open the CommandButton.

Anyone know what I can change to get it to work?

 

[Russell_Leaves]

Hi All.

Have I upset someone? I have re-read the post and cannot see any reason. In re-reading the question, it makes sense too.

Should I be patient and wait for the right person to respond?