View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey ExcelMonkey is offline
external usenet poster
 
Posts: 553
Default Feed Multiple Comb Boxe with same list

I have multiple combo boxes. I want to feed them with the same list. What is
the easiest way to do this? Do you create a custom collection an then
iterate thought it and feed the list to each item in collection? How would
you do this if you had alot of combo boxes (i.e. how do you add many - say
50). I realise I can use Data Validation too. But want to understand the
combo box approach.

Thanks

EM