Are you wanting to do this through VB code or in Excel itsself?
And is the UI fully in VB, or Excel/VB combined?