View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
leerem leerem is offline
external usenet poster
 
Posts: 88
Default Screen Width & Height

How can I increase the size of the form to the screen size.

I used the following but this produced an error. Variable Not defined


Sub Userform Initialize()
with Userform1
.Width=Screen.Width
.Height=Screen.Height
End With
End Sub

How can I increase the size of the userform to the screen size as this form
will be used on multiple screens of different sizes.

Regards
Lee