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 *