Drop down box replication

  • Thread starter Thread starter ISKME
  • Start date Start date
I

ISKME

I need to create 300 drop down boxes in a worksheet. I
know how to replicate the boxes 300 times, but is there a
way to automatically link the boxes to the cell the box
resides in? For example drop down box 1 cell link C1,
drop down box 2 cell link C2...

The fill down method does not seem to work when dealing
with drop down boxes. Is there another way?
 
Here's a way...:
Sub CreateDDs()
With ActiveSheet.DropDowns
For i = 1 To 300
.Add(Range("A:B").Width, Range("A1").Resize(i).Height, 72,
12).LinkedCell = "c" & (i + 1)
Next
End With
End Sub

Bob Umlas
Excel MVP
 
Back
Top