make a combo box repeat for entire column?
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
|