Hello,
Could someone please write me a quick macro that when I edit a cell in Column A it checks the value I inputted and displays a message if it is lower than the last value. E.G.
A1 - 0
A2 - 1
A3 - 2
A4 - 0 - Display a message when this value is entered.
All I have at the moment is this, and I cant seem to get it to work properly with my requirements.
Thanks
Please Login or Register to view this content.
Hi,
One way
RgdsPlease Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Richard, I came up with something similar, but I added a check to see if Target is in Row 1, otherwise the offset will bomb.
Then again, Data Validation could be used with a similar result, VBA-free.Please Login or Register to view this content.
you can do it with data validation
in a2 validate as allow/custom
=A2>=A1
drag down
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
Hi Teylyn,
Yes agreed and a good point
Rgds
Thanks for the great response guys. Thanks especially to teylyn and Richard.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks