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?

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?