Greetings,

I've set up a simple Combo Box in my Excel spreadsheet and it's working fine.

However, in order to get it to work, I had to set up the ListFillRage field using the values in the range "x3:x19" (17 rows, one column.)

But What I REALLY want to do is set up this ListFillRage field so the range of values to choose from is from the "a1:a17" range. (A single ROW of data, not a single COLUMN of data.)

But no matter how I tried to get that to work, it didn't. It would only show the first value, and not the remaining 16 values. And yes, I played around with the ListRows field (currently 17, but I changed it down to 1) and that didn't work, and I also played around with the BoundColumn field and the ColumnCount field. All to no avail.

I found this exact question, posted in 2007, via a Google search, but with no answer.

Certainly this can be done. Yes?

Thanks in advance for any replies.