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

"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 *

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 *

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 *

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 *

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 *