Funny you should mention that, I was going to ask if you might be able to
suggest a good book or two that might be helpful. I was nominated here at
work to learn as
much as I can so we can start automating more of our daily tasks. I have
been able to complete a couple programs but they were less complicated. I
will try to pick up that book before Monday. Thanks again for your help and
suggestions. Take care and have a great weekend!


To be honest, I'm wondering whether the best course of action for you to take
is to read a good book about creating userforms, such as John Green's "Excel
2002 VBA Programmer's Reference" (to which I contributed some chapters).

The reason I suggest that is the technique of refering to a userform in the way
I've shown is a somewhat advanced one, which I fear you might not be ready to
employ.

Regards

Stephen Bullen
Microsoft MVP - Excel
www.oaltd.co.uk