I have created a customizeable userform function. The problem is, if I do not
show the different controls at runtime, the size of the form contains the
space where they would be. Is there a way to easily resize the form by taking
out the unused space?

take a look at http://www.oaltd.co.uk/Excel/Default.htm and grab
FormFun.zip.

--
__________________________________
HTH

Bob

"jayklmno" wrote in message
...
I have created a customizeable userform function. The problem is, if I do
not
show the different controls at runtime, the size of the form contains the
space where they would be. Is there a way to easily resize the form by
taking
out the unused space?

Very Helpful, but unfortunately too much to tackle to edit down to what I need.

I will probably use that in the future... thanks!