|
- Private Sub Worksheet_SelectionChange(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- If Target.Address <> [e3].Address Then Exit Sub
- With Target.Validation
- .Delete
- If Sheets(1).[f20] = 1 Then
- Dim arr, s$, i&
- arr = Sheets(1).[a5:a15]
- For i = 1 To UBound(arr)
- If arr(i, 1) = "" Then Exit For
- s = s & "," & arr(i, 1)
- Next i
- Target = ""
- .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=Mid(s, 2)
- Else
- Target = Sheets(1).[b20]
- .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:=xlBetween, Formula1:=Target
- End If
- End With
- End Sub
复制代码 |
|