View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Populate a combobox

Why not fill them at the same time.

Combobox1.AddItem Cells(rw,1)
Combobox2.AddItem cells(rw,2)

--
Regards,
Tom Ogilvy

"Rory" wrote in message
...
I currently have combobox1 that looks to a hidden sheet
and uses the first column (name) to populate (removing
duplicate occurences of the name). What I need to do now
is populate combobox2 based on the combobox1, that pulls
data from the second column of the hidden sheet, but only
those where column 1 equals combobox 1.