View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
HotRod HotRod is offline
external usenet poster
 
Posts: 147
Default Can you "duplicate" "copy" listboxes and code to multiple cells?

Tough question, I've placed a "list box" in a cell that allows for multiple
selections and has some code behind it. Now I'd like to do the same thing
for every other cell in that column, basically I want to apply the "list
box" to all cells in that column but I want it to make the adjustments so
that the code now writes the text to B1 then B2 then B3 etc. Is this
possible or do I need to manually create each control for all 200+ cells?