|
- Sub suwjts()
- re:
- sm = InputBox("请输入图书编号:", "图书编号查询:")
- If sm = "" Then End
- sl = Application.CountIf(Range("A:A"), sm)
- If sl > 0 Then
- rng = Range("A4", Cells(Rows.Count, "A").End(3).Offset(, 13))
- For i = UBound(rng) To 1 Step -1
- If rng(i, 1) = sm Then
- If rng(i, 9) = "借出" And rng(i, 12) <> "" Then
- a = i + 3
- MsgBox sm & " 此书可以外借!"
- arr = Range("A" & a).Resize(, 3)
- Range("A" & UBound(rng) + 4).Resize(, 3) = arr
- ActiveWindow.ScrollRow = UBound(rng) + 4
- Cells(UBound(rng) + 3, 1).Select
- Exit For
- ElseIf rng(i, 9) = "" Then
- a = i + 3
- MsgBox sm & " 此书可以外借!"
- ActiveWindow.ScrollRow = a
- Cells(a, 1).Select
- Exit For
- ElseIf rng(i, 9) = "借出" And rng(i, 12) = "" Then
- mb = MsgBox(sm & "此书已借出,不能再借!" & Chr(10) & Chr(10) & "最后一次借出在第" & i + 3 & "行!" & Chr(10) & Chr(10) & "是否重新输入编号?", 4)
- If mb = 6 Then
- GoTo re
- Else
- Cells(i + 3, 1).Select
- End
- End If
- End If
- End If
- Next
- Else
- With Sheets("书目")
- Set d = .Range("B:B").Find(sm, , , 2)
- If d Is Nothing Then
- mb = MsgBox("没编号为" & sm & "的图书!" & Chr(10) & Chr(10) & "是否重新输入编号?", 4)
- If mb = 6 Then GoTo re
- End
- Else
- arr = .Range(d, d.Offset(, 2))
- mb = MsgBox(sm & " 此书在书目中存在,未出现在借阅表中,尚未借出!" & _
- Chr(10) & Chr(10) & "书名是:" & arr(1, 3) & Chr(10) & Chr(10) & "是否要外借?", 4)
- If mb = 6 Then
- i = Cells(Rows.Count, 1).End(3).Row + 1
- Cells(i, 1).Resize(1, 3) = arr
- ActiveWindow.ScrollRow = i
- Cells(i, 1).Select
- Else
- GoTo re
- End If
- End If
- End With
- End If
- End Sub
复制代码 |
|