VBA to check if cell A1 in workbook 1 equals cell A1 in workbook 2

**Rerock** · 09-19-2014, 12:32 PM

Hi,
I have two workbooks open at the same time.

I would like to have a simple IF statement that checks whether cells match on both workbooks.

Ideally, it would work similar to this (which doesn't work BTW):

Please Login or Register  to view this content.

Is there is a way to modify the IF statement so that the WORKBOOK_1_NAME & range work? If it's not possible, what would be the easiest way to accomplish it?

Thanks in advance!

**mikeTRON** · 09-19-2014, 12:41 PM

Yes there is a way.

So read through this to learn about workbooks, worksheets, and ranges.
http://www.excel-easy.com/vba/workbo...et-object.html

Basically you want to use an excel cell to define the workbook
then you can use a variable to define it, then use the variable to drop into the needed code.

Please Login or Register  to view this content.

**Rerock** · 09-19-2014, 01:06 PM

I tried the code you posted, but couldn't get it to work. I then clicked on the link you posted, amended my original code a little bit, and whala; it worked! THANKS FOR THE HELP!

Here is what I ended up with:

Please Login or Register  to view this content.

VBA to check if cell A1 in workbook 1 equals cell A1 in workbook 2

LinkBack

Thread Tools

Rate This Thread

Display

VBA to check if cell A1 in workbook 1 equals cell A1 in workbook 2

Re: VBA to check if cell A1 in workbook 1 equals cell A1 in workbook 2

Re: VBA to check if cell A1 in workbook 1 equals cell A1 in workbook 2

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Check if any cell in range contains value and copy that value to another workbook

[SOLVED] Code to copy data from another workbook where offset cell equals "none"

A function to check if a cell is populated when the workbook is opened

Macros to check if any cell value has changed before closing workbook

check cell values from other workbook

Bookmarks

Bookmarks

Posting Permissions