UserForm when opening workbook will not fill screen

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anna B - 28 Feb 2006 18:24 GMT

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

Reply to this Message

Anna B - 28 Feb 2006 18:30 GMT

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.

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

Reply to this Message

Ron de Bruin - 28 Feb 2006 18:35 GMT

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

Signature

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

> 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.
>
>> I have a user form that I want to have open when

Reply to this Message

davesexcel - 28 Feb 2006 18:39 GMT

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

Signature

davesexcel

Reply to this Message

Anna B - 28 Feb 2006 19:48 GMT

Thank you both, either option works great!

> 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

Reply to this Message