|
本帖最后由 zglibk 于 2022-1-22 12:36 编辑
- Private Sub Worksheet_Change(ByVal Target As Range)
- Dim rx&, Rng As Range
-
- Target.Value = UCase(Target.Value)
- ITEM_NO = Target.Value
- For Each SH In Worksheets
- If SH.Name <> "YAO&HUI" Then
- rx = SH.Cells(Rows.Count, 5).End(xlUp).Row
- Set Rng = SH.Range("E2:E" & rx).Find(ITEM_NO, LookAt:=1)
- With Worksheets("YAO&HUI")
- Select Case SH.Name
- Case "OB"
- If Not Rng Is Nothing Then MsgBox Rng.Offset(0, 45).Value: Exit For
- Case "ELK"
- If Not Rng Is Nothing Then MsgBox Rng.Offset(0, 17).Value: Exit For
- Case "YARGICI"
- If Not Rng Is Nothing Then .Cells(Target.Row, 23) = Rng.Offset(0, 21).Value: Exit For
- End Select
- End With
- End If
- Next
- End Sub
复制代码 |
|