Find & replace the data with Msgbox

Hi,
I am looking for a macro that does the things mentioned below
macro will be placed in macro.xlsm & book1.xlsx is located at different place so the path should be hardcoded in the macro & sheet name can be anything

I need a msgbox & in that msgbox I will put what we have to find in book1.xlsx & after finding that data we have to replace it with the data & for that also i need a msgbox & i will put the data in that msgbox & data will be replaced in book1.xlsx

In Book1.xlsx we have to look in sheet1(sheet1 will be hardcoded in the macro so that i can change it as per my needs)
In Book1.xlsx in sheet1 we have to find the data in Column A(Column A should be hardcoded in the macro so that i can change it as per my needs)



Thnx For the Help

msgbox can NOT accept input data. however, INPUTBOX() can. if you use the latter, and you want to find and replace data in column ''A'', you might want to look into the .column property of the range object. see here:

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

and when you use that, you can also use the find method in conjunction with that to find anything in a given column. and when you do that, you can then replace it appropriately.

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

Thnx for the info vba_php , So i need inputbox instead of msgbox

Yes that's correct you need to use an input box and not a message box

I never used any inputbox before & i dont how to create it so plz help Sir

It's very simple if you use a message box, this is your code:

Please Login or Register  to view this content.

And if you use an input box this is your code:

Please Login or Register  to view this content.

No Problem
But plz help me in solving this macro
I dont know much about vba + I never used any inputbox, It is slightly new for me so plz have a look into it

Please Login or Register  to view this content.

I dont want to harcode what i have to find & what i have to replace in the macro

Bcoz it can be anything
So some msgbox like that is needed for that so that when the macro will run that will pop up & will ask what i have to find &will ask with which data it should be replaced like that i am looking for

Originally Posted by dumdumbum

So some msgbox like that is needed for that so that when the macro will run that will pop up & will ask what i have to find &will ask with which data it should be replaced like that i am looking for

i just gave you that

Sorry vba_php, My mistake
Actually plz see the below macro & plz correct the below macro, it has errors
I modified the macro as per my needs bcoz the data which we have to find & replace is with different workbook & macro will be placed in different workbook
So plz have a Relook Sir

Please Login or Register  to view this content.

you say it has errors. where does it break? where does it error? the only thing i can possibly see as an issue is the line where the replacement is happening. those 3 lines of code will manipulate the worksheet that has the FOCUS.

Correct Sir, Yes from there only there is a issue

I see no issue. upload a file that has an error in it.

Macro will be placed in macro.xlsm & the second file i have attached below

there is no code in you workbook

Macro will be placed in macro.xlsm Sir
Macro i already shared & plz place the macro to a newe file & run the macro Sir & then see the issue Sir

you know, what I'm trying to tell you is to run the macro yourself and see what it gets you. do you not want to do that? just tell me that, and I'll do it. I don't know if you realize this or not, but this is extremely simple. and I already gave you the answer that works fine.

Run Time Error:1004
application defined or object defined error
Highlighted line:

Columns("A:A").Replace What:=s, Replacement:=s2, LookAt:=xlPart, _
SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False, FormulaVersion:=xlReplaceFormula2

I downloaded your file, put the code into it that I *wrote*, and I got no error. see images:

Macro will not be placed in leverage file, macro will be in different file

I know that. but your workbooks.open() method of line of code was not what was failing, according to you.

I can replicate your issue exactly by running EXACTLY the code that you ran, but i won't be able to until later on tonight. if you solve it by then, let us know.

Np Take Ur Time Sir

Thnx Alot Vba_php for helping me in solving this Problem
Problem Solved
Have a Awesome Day

you too. glad to hear. =)