|
本帖最后由 byhdch 于 2012-6-19 13:43 编辑
A09byhdch VBA第19讲作业
- Private Sub UserForm_Initialize()<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />
- Dim arr, arr1(1 To 100, 1 To 1)
- Dim x As Integer
- Dim d As New Dictionary
- arr = Range("c5:e14")
- For x = 1 To UBound(arr)
- If arr(x, 1) = "" Then arr(x, 1) = arr(x - 1, 1)
- d(arr(x, 1)) = d.Count
- arr1(d.Count, 1) = arr(x, 1)
- Next x
- 部门.List = arr1
- End Sub
- Private Sub 部门_Change()
- Dim arr, arr1(1 To 100, 1 To 1), arr2(1 To 100, 1 To 1), arr3(1 To 100, 1 To 1)
- Dim x, k, m, n As Integer
- Dim d As New Dictionary
- arr = Range("c5:d14")
- For x = 1 To UBound(arr)
- If arr(x, 1) = "" Then arr(x, 1) = arr(x - 1, 1)
- If arr(x, 1) = "销售部" Then
- k = k + 1
- arr1(k, 1) = arr(x, 2)
- ElseIf arr(x, 1) = "客服部" Then
- m = m + 1
- arr2(m, 1) = arr(x, 2)
- ElseIf arr(x, 1) = "财务部" Then
- n = n + 1
- arr3(n, 1) = arr(x, 2)
- End If
- Next x
- If 部门.Value = "销售部" Then ListBox1.List = arr1
- If 部门.Value = "客服部" Then ListBox1.List = arr2
- If 部门.Value = "财务部" Then ListBox1.List = arr3
- End Sub
- Private Sub 部门_Enter()
- 部门.DropDown
- End Sub
- Private Sub TextBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
- If Sheet1.Range("D:D").Find(ListBox1.Value).Row = Sheet1.Range("E:E").Find(TextBox1.Value).Row Then
- MsgBox "登录成功"
- Exit Sub
- Else
- MsgBox "密码错误,请重新输入"
- End If
- End Sub
- Private Sub CommandButton2_Click()
- Unload Userform1
- End Sub
复制代码
A09byhdch VBA第19讲作业.rar
(41.41 KB, 下载次数: 4)
|
评分
-
查看全部评分
|