Is it possible for Instr to be started at the middle of a text?

[Peterso]

let say I have a text x="I am a happy man"

If I set y=Instr(x, a), y is equal to 3. However I want y to be 9 which is the location of the "a" in "happy". How can I do

 

[Michael M]

Sort of....but I don't think it is as strong as you might need.
Have a look here at Example #2

https://trumpexcel.com/excel-vba-instr/

 

[Michael M]

Maybe this....

Sub MM1()
y = InStr(1, ActiveCell, "ha") + 1
End Sub

 

[Akuini]

let say I have a text x="I am a happy man"

If I set y=Instr(x, a), y is equal to 3. However I want y to be 9 which is the location of the "a" in "happy". How can I do

I don't understand the requirement here.

If you know beforehand where to start, say from the 8th character then it would be like this:

x = "I am a happy man"
y = InStr(8, x, "a")

but if you want to find the 3rd occurence of "a" then it would be like this:

x = "I am a happy man"
y = InStr(1, x, "a")
y = InStr(1 + y, x, "a")
y = InStr(1 + y, x, "a")

or do you want to find "a" in "happy"? since we know "a" is the second char of "happy", then:

y = InStr(1, x, "happy") + 1

 

[Peterso]

y=instr(8,x,"a") is what I want. Thanks a lot!

 

[Akuini]

y=instr(8,x,"a") is what I want. Thanks a lot!

Your welcome.