I use the code in this link to resize my userforms
http://www.andypope.info/vba/resizeform.htm
It works great.
However I have various frames, listboxes and so on my userform - They need to be resized as well - anybody know of a smart way to do this - else I guess I gotta code it the long way. I guess the problem is that Textboxes and other have to have a minimum height depending on the font size and so on.
Any comments on how best to do this would be much appreciated
http://www.andypope.info/vba/resizeform.htm
It works great.
However I have various frames, listboxes and so on my userform - They need to be resized as well - anybody know of a smart way to do this - else I guess I gotta code it the long way. I guess the problem is that Textboxes and other have to have a minimum height depending on the font size and so on.
Any comments on how best to do this would be much appreciated