Working with a combobox

O

OkieViking

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
 
T

Tom Ogilvy

Combobox1.List = Selection

rows are selected from a combobox. Not columns.

--
Regards,
Tom Ogilvy

OkieViking said:
I am trying to write a macro that will process a range selected by the
Click to expand...
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?
 
O

OkieViking

I am trying to re-create the sort userform in excel. I can't get the drop down menus that ask me what column to sort by.
 
T

Tom Ogilvy

Private Sub UserForm_Initialize()
With Worksheets("Data")
Set rng = .Range(.Cells(1, 1), .Cells(1, 1).End(xlToRight))
End With
ComboBox1.List = Application.Transpose(rng)
Combobox2.List = Combobox1.List
Combobox3.List = Combobox1.List
End Sub

As an example.

--
Regards,
Tom Ogilvy




OkieViking said:
I am trying to re-create the sort userform in excel. I can't get the drop
Click to expand...
down menus that ask me what column to sort by.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?
 
Top