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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.