I am working on a VB macro that takes spreadsheet from a third party vendor
and grabs the headers for each column. It then allows to the user of the form
to line up these incoming headers adjacent to my preset ones in two side by
side list boxes. Based on which Preset Header the incoming ones are next to,
I want to apply specific formatting to these incoming data ranges.

I was thiking the best way to do this would be to create an object for each
Column that would have the three following properties:

Header Text
ColumnLetter (Which physical column it is on the sheet)
FormatType (Which of my predefined formats it should use after I have sorted
the incoming spreadsheet headers)

Questions:

How do I create the objects if this is the easiest way to solve my problem?
How do I create these properties inside of the objects?
How do I create my own custom formatting?

PLEASE HELP!!!! Thank you!!!

Nate