-
How to concatenate ComboBox name
So I 12 combo boxes with names "ComboBox1" through "ComboBox12" respectively. Each ComboBox has the same drop-down items. Instead of me coding each one individually, is there a way to loop through them? For example, I have the following code:
For c = 1 To 12
combo = "ComboBox" & c
With Sheet1.combo
.Clear
.AddItem "cat"
.AddItem "dog"
.AddItem "fish"
.AddItem "bird"
End With
Next
But it always says "combo" not recognized, or something down those lines.
Any help/suggestions are appreciated.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules