Transpose range for drop down list
 

Hi there,

I have a drop down list which refers to a range of data.
As far as I understood, the range of data has to be defined vertically (in a
column) to be used by the drop down list. My issue is that the range of data
I would like to refer to is set in a row.. How can I link the drop down list
to this horizontal range (ideally without copy pasting the range with paste
special Transpose)?

Transpose range for drop down list
 

Try using a Combobox instead and populate it with vba in a single row.
Private Sub ComboBox1_DropButtonClick()
ComboBox1.Clear
ComboBox1.AddItem Sheet1.Range("A1").Value
ComboBox1.AddItem Sheet1.Range("B1").Value
ComboBox1.AddItem Sheet1.Range("C1").Value
ComboBox1.AddItem Sheet1.Range("D1").Value
ComboBox1.AddItem Sheet1.Range("E1").Value
ComboBox1.AddItem Sheet1.Range("F1").Value
ComboBox1.AddItem Sheet1.Range("G1").Value
ComboBox1.AddItem Sheet1.Range("H1").Value
ComboBox1.AddItem Sheet1.Range("I1").Value
ComboBox1.AddItem Sheet1.Range("J1").Value
End Sub

"Bonobo" wrote in message
...
Hi there,

I have a drop down list which refers to a range of data.
As far as I understood, the range of data has to be defined vertically (in
a
column) to be used by the drop down list. My issue is that the range of
data
I would like to refer to is set in a row.. How can I link the drop down
list
to this horizontal range (ideally without copy pasting the range with
paste
special Transpose)?

Transpose range for drop down list
 

I would prefer not to change to a combobox... isn't there a similar way with
a drop down list?

"ctm" wrote:

Try using a Combobox instead and populate it with vba in a single row.
Private Sub ComboBox1_DropButtonClick()
ComboBox1.Clear
ComboBox1.AddItem Sheet1.Range("A1").Value
ComboBox1.AddItem Sheet1.Range("B1").Value
ComboBox1.AddItem Sheet1.Range("C1").Value
ComboBox1.AddItem Sheet1.Range("D1").Value
ComboBox1.AddItem Sheet1.Range("E1").Value
ComboBox1.AddItem Sheet1.Range("F1").Value
ComboBox1.AddItem Sheet1.Range("G1").Value
ComboBox1.AddItem Sheet1.Range("H1").Value
ComboBox1.AddItem Sheet1.Range("I1").Value
ComboBox1.AddItem Sheet1.Range("J1").Value
End Sub

"Bonobo" wrote in message
...
Hi there,

I have a drop down list which refers to a range of data.
As far as I understood, the range of data has to be defined vertically (in
a
column) to be used by the drop down list. My issue is that the range of
data
I would like to refer to is set in a row.. How can I link the drop down
list
to this horizontal range (ideally without copy pasting the range with
paste
special Transpose)?

Transpose range for drop down list
 

Drop Down lists (Data Validation) works for a column OR a row of data. What
seems to be the problem?

"Bonobo" wrote:

Hi there,

I have a drop down list which refers to a range of data.
As far as I understood, the range of data has to be defined vertically (in a
column) to be used by the drop down list. My issue is that the range of data
I would like to refer to is set in a row.. How can I link the drop down list
to this horizontal range (ideally without copy pasting the range with paste
special Transpose)?