Transpose range for drop down list

  • Thread starter Thread starter Bonobo
  • Start date Start date
B

Bonobo

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)?
 
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
 
I would prefer not to change to a combobox... isn't there a similar way with
a drop down list?
 
Drop Down lists (Data Validation) works for a column OR a row of data. What
seems to be the problem?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear a "moving" range offset from Target 31
Eliminate blanks while copy row and transpose 11
Set Column choice to a variable from a Drop Down 4
Define the Range of a drop-down list 5
Run macro from active workbook whose name keeps changing 20
Name the range AFTER copied to new sheet 6
Transpose code has ceased to transpose 3
Dependent drop down dynamic range formula, off sheet. 7

Back
Top