Restrict Values That Can Be Entered in a Cell

[Blokeman]

Hi,

How to insert in the macro below a check that if a user enter value 20 or higher then a message box and clear contents.

Thanks

Please Login or Register  to view this content.

[walruseggman]

check that if a user enter value 20 or higher then a message box and clear contents

Where are they entering the value you want checked? Into the following cell?

Please Login or Register  to view this content.

[Blokeman]

Hi walruseggman,

Upload workbook with complete code (Module1).Entering the value in row 12 (B12:K12).

Thanks

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Can this help?

Please Login or Register  to view this content.

[mikerickson]

Data Validation will do this without any VBA.

[Blokeman]

@JOHN, works perfectly, Thanks
@mikerickson, I've tried data validation but it doesn't work coz I'm using macro to enter value, It will only work if you enter the value manually.

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[mikerickson]

The OP code shows the suspect value already in the cell. If the value is being put in the cell with VBA, it might be better to do the validation before actually putting it into a cell. VBA usually precludes UnDo and you might want to tell the user that something is wrong before they lose the data that was previously in the cell.

[Blokeman]

Hi JOHN,

Sorry to bother you again but I want to add another range (E5:N5), but this time not greater than 2240 with different message.

Thanks