Find Text in Formula

**neilshaw** · 07-07-2011, 06:26 PM

Hi there

I have a sheet that processes a macro upon a worksheet change event. When a cell is changed on one sheet, a picture of a persons signature (jpg) is inserted on another sheet. I can specify the cell that I want the jpg to appear easily enough, however I want the function to search for some text "Yours Sincerely" and insert the picture at that cell. The problem comes in that the "Yours Sincerely" appears as part of a formula (it is based on an 'If' formula), so when I search for it, it can't find it. So I need it to find the value of the cell. Any ideas anyone?

Thanks

Neil

**TMShucks** · 07-07-2011, 07:14 PM

Try something like:

Sub FindYS()
'
' C6 contains:   ="x "&F9&" y"
' F9 contains:   Yours Sincerely

MsgBox Cells.Find(What:="Yours Sincerely", _
    After:=ActiveCell, _
    LookIn:=xlValues, _
    LookAt:=xlPart, _
    SearchOrder:=xlByRows, _
    SearchDirection:=xlNext, _
    MatchCase:=False, _
    SearchFormat:=False).Address
End Sub

Regards

Thread: Find Text in Formula

Thread Tools

Display

Find Text in Formula

Re: Find Text in Formula

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions