I have a user form that I want to have open when

Sorry, let me try this again. I have a userform that I want to have open
when the workbook opens. I have managed to do this, but the form only fills
up part of the screen. Is there a way to make it fill up the whole screen?
Thanks for your help.

"Anna B" wrote:

I have a user form that I want to have open when

Hi Anna

You can use this event in the userform

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Anna B" wrote in message ...
Sorry, let me try this again. I have a userform that I want to have open
when the workbook opens. I have managed to do this, but the form only fills
up part of the screen. Is there a way to make it fill up the whole screen?
Thanks for your help.

"Anna B" wrote:

I have a user form that I want to have open when

go back into visual basics click on the userform and click on the
diamonds on the sides and stretch it out till it is as big as you want
it, there are lots of papers on doing this with a code but I can't find
it in my library at the moment


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517426

Thank you both, either option works great!



"davesexcel" wrote:


go back into visual basics click on the userform and click on the
diamonds on the sides and stretch it out till it is as big as you want
it, there are lots of papers on doing this with a code but I can't find
it in my library at the moment


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517426