Hi TG,

What you need is a Class Module. JW explains how here :
http://www.j-walk.com/ss/excel/tips/tip44.htm

HTH