Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Resize Userform?
Hi Is it possible for one to resize an userform after it's activated? Cheer -- hc ----------------------------------------------------------------------- hce's Profile: http://www.excelforum.com/member.php...nfo&userid=351 View this thread: http://www.excelforum.com/showthread.php?threadid=27187 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Resize Userform?
"hce" wrote in message
... Is it possible for one to resize an userform after it's activated? Hi hce, Yes. Just set the Width and Height properties of the UserForm to whatever new values you want them to have. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Resize Userform?
Rob,
I have used this technique for showing error frames and the like on the same form, but have a small annoyance. Have you ever had the problem when doing this that on some machines the resized form shows all of the extra controls okay, but on others, parts get clipped? If so, what was your solution? -- HTH RP "Rob Bovey" wrote in message ... "hce" wrote in message ... Is it possible for one to resize an userform after it's activated? Hi hce, Yes. Just set the Width and Height properties of the UserForm to whatever new values you want them to have. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Resize Userform?
I have had this issue also. Generally if rm is the control furthest to the
right, then I have set the forms scalewidth rm left + rm width plus a margin of 64 hth -- Patrick Molloy Microsoft Excel MVP --------------------------------- I Feel Great! --------------------------------- "Bob Phillips" wrote in message ... Rob, I have used this technique for showing error frames and the like on the same form, but have a small annoyance. Have you ever had the problem when doing this that on some machines the resized form shows all of the extra controls okay, but on others, parts get clipped? If so, what was your solution? -- HTH RP "Rob Bovey" wrote in message ... "hce" wrote in message ... Is it possible for one to resize an userform after it's activated? Hi hce, Yes. Just set the Width and Height properties of the UserForm to whatever new values you want them to have. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Resize Userform?
Hi Patrick,
That is the same sort of approach I tried, I just hoped for something more scientific <vbg -- HTH RP "Patrick Molloy" wrote in message ... I have had this issue also. Generally if rm is the control furthest to the right, then I have set the forms scalewidth rm left + rm width plus a margin of 64 hth -- Patrick Molloy Microsoft Excel MVP --------------------------------- I Feel Great! --------------------------------- "Bob Phillips" wrote in message ... Rob, I have used this technique for showing error frames and the like on the same form, but have a small annoyance. Have you ever had the problem when doing this that on some machines the resized form shows all of the extra controls okay, but on others, parts get clipped? If so, what was your solution? -- HTH RP "Rob Bovey" wrote in message ... "hce" wrote in message ... Is it possible for one to resize an userform after it's activated? Hi hce, Yes. Just set the Width and Height properties of the UserForm to whatever new values you want them to have. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Resize Userform?
Hi Bob,
It sounds like Patrick has the same approach I use. Plenty of margin for error. <g -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * "Bob Phillips" wrote in message ... Rob, I have used this technique for showing error frames and the like on the same form, but have a small annoyance. Have you ever had the problem when doing this that on some machines the resized form shows all of the extra controls okay, but on others, parts get clipped? If so, what was your solution? -- HTH RP "Rob Bovey" wrote in message ... "hce" wrote in message ... Is it possible for one to resize an userform after it's activated? Hi hce, Yes. Just set the Width and Height properties of the UserForm to whatever new values you want them to have. -- Rob Bovey, MCSE, MCSD, Excel MVP Application Professionals http://www.appspro.com/ * Please post all replies to this newsgroup * * I delete all unsolicited e-mail responses * |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I could NOT resize the axis title but excel allows me to resize gr | Charts and Charting in Excel | |||
I could NOT resize the axis title but excel allows me to resize gr | Charts and Charting in Excel | |||
Resize name box | Setting up and Configuration of Excel | |||
Linking userform to userform in Excel 2003 | Excel Programming | |||
Need some help with Resize. Thanks | Excel Programming |