Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
maximizing the size of a UserForm | Excel Programming | |||
UserForm Size On Different Computers | Excel Programming | |||
Print UserForm A4 size | Excel Programming | |||
Userform size limitation | Excel Programming | |||
Userform Size | Excel Programming |