I'd like to populate my listbox with values from cells b1:f1. If I put the
following entry into the RowSource property, I only get the value in b1 to
populate my listbox:

sheet1!b1:f1

I've noticed that if the values in the worksheet run down a column instead
of across a row, I get what I want. Thus, RowSource property works with this
entry:

sheet1!a2:a6

Sadly, I need to be able to populate my listbox from cells across a row and
not down a column. Can I adjust my value in the RowSource property to give me
what I want? If not, is there another way to do this? An example would be
nice.

Thanks!