Error message if value is noth within range

[vonrainer]

Hello,

I would like to make a macro (Workbook_SheetChange) to display an error message if the value entered is not within a range of 1000000 and 3999999.
I already have code to display error message if the entered value already exists in the worksheet

How can I set this up?

[Kaper]

Add another test to the code you already have. The test will be probably (but it depends on the code you already have):

Please Login or Register  to view this content.

[vonrainer]

Adding this gave me an error.

Below is the code i currently have:

Please Login or Register  to view this content.

Where should I add the new code?

[Kaper]

How about adding it at the beginning :

Please Login or Register  to view this content.

By the way - why not use just data validation in the spreadsheet?