PDA

View Full Version : combobos rowsource



mpearce
05-21-2010, 08:11 AM
Is it possible to have the row source populate based on a row of values versus a column of values?

mdmackillop
05-21-2010, 08:45 AM
Use the List method and transpose the range

Private Sub UserForm_Initialize()
ComboBox1.List() = Application.Transpose(Range("Data").Value)
End Sub