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?

Can you "duplicate" "copy" listboxes and code to multiple cells?
 

You can do it manually or you can write code to do it.

Do you mean listbox or combobox. In either case, there are two types of
listboxes and 3 types of comboboxes. Which are you using?

--
Regards,
Tom Ogilvy

"HotRod" wrote in message
...
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?