Hello,

I'm having a problem with this code when viewed online. Here's the code:

VB Code:
  1. Private Sub UserForm_Initialize()
  2.  
  3. Dim OldState As Integer
  4. OldState = Application.WindowState
  5. Application.WindowState = xlMaximized
  6. Me.Top = Application.Top
  7. Me.Left = Application.Left
  8. Me.Height = Application.Height
  9. Me.Width = Application.Width
  10. Application.WindowState = OldState
  11.  
  12. End Sub
Evidently I must explicitly define "Application". So when I add:

Dim xlApp as Excel.Application

I'm unsure of what to set it to:
Set xlApp = ????????

I tried adding "Excel.Application" to each line:
OldState = Excel.Application.WindowState
Excel.Application.WindowState = xlMaximized
etc....
but I'm still getting error 1004, object not SET. What do I set the object to? This is straight Excel/VBA.

Thank you,
CJ