userform size
 

Hello:

I want to make a userform width smaller then 93. Is it possible? I tried a
few way but will not let me. Any help?

Thanks

userform size
 

Set the width with the Initialize event


Code:
--------------------
Option Explicit


Private Sub UserForm_Initialize()
Me.Width = 90
End Sub
--------------------


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30147

userform size
 

It does not help. try it you'll see that after 93 it will not get less than
that. Is there any way to have the userform smaller then 93 width?

Thanks.





"royUK" wrote:


Set the width with the Initialize event


Code:
--------------------
Option Explicit


Private Sub UserForm_Initialize()
Me.Width = 90
End Sub
--------------------


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30147

userform size
 

The smallest width that I can get is about 89


--
royUK

Hope that helps, RoyUK
For tips & examples visit my 'web site
' (http://www.excel-it.com)
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=30147

userform size
 

is there any way to make them smaller?




"art" wrote:

Hello:

I want to make a userform width smaller then 93. Is it possible? I tried a
few way but will not let me. Any help?

Thanks