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

  • Thread starter Thread starter HotRod
  • Start date Start date
H

HotRod

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to do a simple clean of one column by copying and pasting(finding and replacing) phrases in adj 4
Conditional listbox cell populating 4
VBA set thick borders around non empty cells in range 0
Code for multiple select of cells 16
Naming non-contigent cells with vba 5
ListBox Remove Certain Text 6
Trying to run excel vba code when cell value changes from empty to entered value. 1
Create if partial match then copy and paste data from one cell to another 1

Back
Top