Hi,
I'm not sure I can help much as VBA is not in my wheel house. But I did find a post from someone (Jack Dahlgren) which may be of use:

http://zo-d.com/blog/archives/progra...-userform.html

I think his post will help with both questions. As an aside, if you are starting with new questions, best to post a new thread. It helps others to find things more quickly.