|
[B10],[C10]情况重新选择:- Private Sub Worksheet_Change(ByVal Target As Range)
- If Target.Count > 1 Then Exit Sub
- If Application.Intersect([b7:c7,b10], Target) Is Nothing Then Exit Sub
- Dim i&, Sht As Worksheet, col%, j&
- Set d = CreateObject("Scripting.Dictionary")
- If Target.Address = "$B$7" Then
- If Target = "" Then Exit Sub
- With Sheets(Target.Value & "")
- Arr = .UsedRange
- For j = 1 To UBound(Arr, 2)
- If Arr(1, j) = "邮箱容量" Then d(Arr(2, j)) = j
- Next
- End With
- [C10] = ""
- With Target.Offset(0, 1).Validation
- .Delete
- .Add 3, 1, 1, Join(d.keys, ",")
- End With
- ElseIf Target.Address = "$C$7" Then
- If Target = "" Then Exit Sub
- With Sheets(Target.Offset(0, -1).Value & "")
- Arr = .UsedRange
- For j = 1 To UBound(Arr, 2)
- If Arr(1, j) = "邮箱容量" Then d(Arr(2, j)) = j
- Next
- End With
- [C10] = ""
- [B10] = ""
- col = d(Target.Value)
- d1.RemoveAll
- For j = 3 To UBound(Arr)
- d1(Arr(j, 1)) = Arr(j, col + 1)
- Next
- k = d1.keys: t = d1.items
- ElseIf Target.Address = "$B$10" Then
- If Target = "" Then
- [C10] = ""
- Exit Sub
- End If
- If d1.exists(CDbl(Target.Value)) Then
- If d1(Target.Value) = "" Then
- MsgBox "没有对应价格。请尝试输入5的倍数;大于100用户请输入50的倍数"
- End If
- [C10] = d1(Target.Value)
- Else
- [C10] = ""
- MsgBox "没有对应价格。请尝试输入5的倍数;大于100用户请输入50的倍数"
- End If
- End If
- End Sub
复制代码 |
评分
-
查看全部评分
|