Combobox1.List = Selection

rows are selected from a combobox. Not columns.

--
Regards,
Tom Ogilvy

"OkieViking" wrote in message
...
I am trying to write a macro that will process a range selected by the
user. I kow how to get the adress/rows and columns of the selected range
(thanks to you guys). I need to populate a combobox with the columns in
text form in the selected range (as in Column B). The user will then select
one of the columns from the combobox, and I need to know which that is (in
number format: 2). How do you do that?

Thanks