|
目标:在A2单元格制作一个下拉菜单,如511,512,513,514,515,516,517,518,521,522,523,524,525,526,531,532,533,534,535,541,542,543,544,545,551,552,553,561,562,563
(1)使选中511后,只出现所有以511开头学生姓名
(2)在B2单元格显示 一(1)班
(3)同时统计所有以511开头学生人数,显示在F2单元格
(4)根据【监考安排】表,在J2单元格显示第1考室监考教师
取巧方法,是否可以 - Private Sub Worksheet_Change(ByVal T As Range)
- If T.Count > 1 Or T.Row <> 2 Then Exit Sub
- If T.Address = "$A$2" Then
- Dim ar, irow%, ends%
- Application.ScreenUpdating = False
- Rows.Hidden = False
- ends = [a65536].End(3).Row
- For irow = 3 To ends
- If Not (Cells(irow, 1) Like T.Value & "*") Then
- Cells(irow, 1).RowHeight = 0
- End If
- Next
- Application.ScreenUpdating = True
- End If
- End Sub
复制代码
|
|