RowSource property in cbox
You could leave the RowSource property empty, and run some alternate code
during initialization as follows:
dim CL as range
For Each CL in Range("BoxSource").Cells
ComboBox1.AddItem CL
Next CL
Change range to whatever you've called yours, and ComboBox1 to the actual
name of your combobox.
"Sam" wrote:
I have a horizontal range named "TranList" that I want to use as the
RowSource of a UserForm combo box. I tried entering the range name into the
RowSource property and using the Transpose function for the range in
UserForm_Initialize but can't seem to get it to work.
Any help would be appreciated.
Thanks,
Sam
|