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?