If condition matched then do nothing Else msgbox with paasword

zyxw1234
Banned
Posts: 253
Joined: 22 Apr 2020, 17:24

If condition matched then do nothing Else msgbox with paasword

Post by zyxw1234 »

Hi Experts,
I am looking for a macro that will do the things mentioned below
If first entire row of 1.xls matches with first entire row of Error.xlsx then do nothing Else A msg box should popup & that msgbox should not be closed without putting paasword & assume paasword would be 123456

Plz note first entire row may be different as shown in the sample file & i may put the first entire row data of error.xlsx to second entire row so plz let me know the changes for that also, so in future i can change it by myself & as per my needs


Note:
Macro will be placed in a macro.xlsm There are 3 files(Macro.xlsm,1.xls & Error.xlsx) & all three files are located in a different path so the path should be hardcoded in the macro for that 2 files
sheet name can be anything
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78462
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: If condition matched then do nothing Else msgbox with paasword

Post by HansV »

OK, that's enough.
Best wishes,
Hans