Hi all,
I need some help. I've excel 2003 and I'm using the searching module from below (works fine):
I need to add the line (see in the code).
![]()
Private Sub Worksheet_Change(ByVal Target As Range) Set s = CreateObject("SAPI.SpVoice") If Target.Address = "$B$1" Then If Application.WorksheetFunction.CountIf(Range("H3:H5000"), Target.Value) > 1 Then Beep For i = 1 To 100 i = i + 1 Next i s.Speak "Check the list" SelectFrm.Show s.Speak "Ready! Scan the Full box quantity." Else On Error GoTo ErrHandler smthng = Range("H3:J5000").Find(Target.Value).Address Range(smthng).Offset(0, 5).Activate ' I want to add here s.Speak value of cell the same row, column -2 s.Speak "Ready! Scan the Full box quantity." End If Else: End If ErrHandler: s.Speak "Not!" For i = 1 To 100 i = i + 1 Next i s.Speak "on the list" MsgBox "Value not found" Range("B1").Activate End Sub











LinkBack URL
About LinkBacks
Register To Reply

Bookmarks