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