The below VBA does prompt users with an information box when anything is typed in the target cells, but I would like the prompts to work when the target cell values are more than 44000 for the one message and more than 3200 for the later. Please advise how I can change or add lines to make this work accordingly.
Please Login or Register to view this content.
Last edited by SheavF; 09-10-2015 at 08:00 AM.
Hi SheavF,
Welcome to the forum!!
Once you put tags around your code as per Rule 3 from here which you recently agreed to when you signed up, I'll try and provide an answer.
Thanks,
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
My co-worker figured it out... I had to remove the quotes from the Target.Value.
Before: If Target.Value > "44000" Then
After: If Target.Value > 44000 Then
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks