Populate listbox on userform

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

This is a piece of code I use to populate a listbox with range A1:Z1:

ListBox4.List = Application.Transpose _
(.Range("A1:Z1").Value)

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain
 
Hi,
I have a userform with a listbox that I would like to
populate. Is there anyway for the rowsource of the listbox
to be a horizontal range?
For example, assume that I have a whole bunch of scenario
names, that run in cells B1, C1, D1, etc.

How do I get this as the rowsource, as Excel seems to only
want a vertical range of data.

Thanks for the help
 
No, a horizontal range is not supported by the rowsource

At least not in Excel 2000 and xl97.
 
Very nice !

Thanks for the help.
-----Original Message-----
This is a piece of code I use to populate a listbox with range A1:Z1:

ListBox4.List = Application.Transpose _
(.Range("A1:Z1").Value)

HTH
--
Michael J. Malinsky
Pittsburgh, PA

"I was gratified to be able to answer promptly,
and I did. I said I didn't know." -- Mark Twain




.
Click to expand...
 
Back
Top