Find Text and input in MSGBOX

Hello
I hope all of you are doing well , My attached file is working fine but I want to modification in it ....

Find the word " EXPECTED" and Note/copy the Row number and paste it into MSGBOX and click OK

My Current code is as below

Please Login or Register  to view this content.

your code does not need to be that long. the methods .find and .findnext will do exactly what you want. I just finished a project for a gentleman in England that used those 2 methods heavily. they find anything, anywhere, if you spec the args correctly. see these:

https://docs.microsoft.com/en-us/off...cel.range.find

https://docs.microsoft.com/en-us/off...range.findnext

Thank you VBA_PHP , i have already tried find fuction which is partly working actually I am stuck to pass(input) the value in MSGBOX of find result

Originally Posted by vikas_newports

Thank you VBA_PHP , i have already tried find fuction which is partly working actually I am stuck to pass(input) the value in MSGBOX of find result

post the code pls.

does this code work for you? I just finished a job for someone that used this exactly same code and it worked fine. I do not like excel for this vary reason. can you test this and see if it turns red for you too? but regardless, the code should work fine cuz it's searching a def'd range, and it's returned to a range as well.

That code can never work, you have got the = & : signs the wrong way round for LookIn

vba_php
above pic code is finding the keyword " 1" as I am already successfully in this step

Please Login or Register  to view this content.

Originally Posted by Fluff13

That code can never work, you have got the = & : signs the wrong way round for LookIn

can you review this

Please Login or Register  to view this content.

If you just want to know the address, try

Please Login or Register  to view this content.

Fluff13, I want to use the activecell address in INPUT field of msgbox , i tried to this but giving error " Type Mismatch"
rw = Application.InputBox("Enter the row number to start from.", "STARTING ROW NUMBER", s)

How about

Please Login or Register  to view this content.

Originally Posted by Fluff13

How about

Please Login or Register  to view this content.

Yes it is working but it is asking for click on OK , how can we avoid it.

Are you saying that you don't want the inputbox at all & to just use the row where expected was found?

actually I am using input box to find my row number of my keyword , then I split the data after the above-inputted row number
if you clear the content from result sheet and run this macro you will get the idea

That won't tell me what you want to do.
Do you want to get rid of the input box & just use the row where expected was found?

yes I want to extract the data right after my keyword available...

In that case remove the input box line & just use

Please Login or Register  to view this content.

Originally Posted by Fluff13

In that case remove the input box line & just use

Please Login or Register  to view this content.

Thanks for great idea which were missing by me .. It is working fine

You're welcome & thanks for the feedback.

is it posible that we just extract the information on Result sheet for next 100 rows
for example starting row num is 15 so we will extract information in from 15 to 115 row number.
it is just becaue I tried on my actual file it is giving error but on sample file it is working fine.

To just look at 100 rows use

Please Login or Register  to view this content.

Originally Posted by Fluff13

To just look at 100 rows use

Please Login or Register  to view this content.

That great, I am inspired by you as I am learning VBA for the last few days and I am getting too much knowledge from this kind of example.
All solved, Appreciate your efforts. God Bless u

Glad to help.