View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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