请大神帮忙看一下如下代码如何修改才能实现上面的功能:
Sub DateDim_click()
Sheets(3).Shapes.Range(Array("Drop Down 6")).Select
If Sheets(2).Range("$F$2") = 1 Then
With Selection
.ListFillRange = ""
.ListFillRange = "Sheet2!$B$3:$B$5"
.LinkedCell = "Sheet2!$F$4"
.DropDownLines = 30
End With
ElseIf Sheets(2).Range("$F$2") = 2 Then
With Selection
.ListFillRange = ""
.ListFillRange = "Sheet2!$C$3:$C$10"
.LinkedCell = "Sheet2!$F$4"
.DropDownLines = 30
End With
ElseIf Sheets(2).Range("$F$2") = 3 Then
With Selection
.ListFillRange = ""
.ListFillRange = "Sheet2!$D$3:$D$17"
.LinkedCell = "Sheet2!$F$4"
.DropDownLines = 30
End With
Else
With Selection
.ListFillRange = ""
.ListFillRange = "Sheet2!$E$3:$E$17"
.LinkedCell = "Sheet2!$F$4"
.DropDownLines = 30
End With
End If
End Sub