Automatic browse through defined range

[BeerKing]

I need a macro that browses through column A and checks each individual cell value each time a value is entered in column B. If the entered value in column B already exists in column A, it should warn with a MsgBox as invalid value.

The macro should run automatically OnEntry.

Anyone up for it??

[jraj1106]

Hi.

Try this:

checkingvalues.xlsm

[BeerKing]

The macro works per se, but it's locked to Sheet1. I have other macros in the file that creates a new sheet for each day, so it has to change the sheet to which it applies, e.g. Sheets(3)