That's what I started with, actually a list with a combo box on top of it so
the user could start to type the value, but I don't really like how it's
working. I was just wondering if it could be done. As for the amount of
rows, no, I could probably start it off with just 200 and then increase in
increments if need be.



"Dave Peterson" wrote:

All 64k rows (or 1MB rows in xl2007???).

Have you thought about using Data|Validation instead?


jjordan wrote:

Hi there,

I'm wondering if there is a way on my spreadsheet I can make the same combo
box (ComboBox1) appear on each row of an entire column through VBA. I
currently have ComboBox1 in row 1 with the list items from VBA code.

thanks, JJ

--

Dave Peterson