Hello everyone, My first time posting here. I'm wondering if someone can help me. I'm trying to receive a pop up message for any number that = to 1200 or > 1200. is there anyway to do this without VBA.
Hello everyone, My first time posting here. I'm wondering if someone can help me. I'm trying to receive a pop up message for any number that = to 1200 or > 1200. is there anyway to do this without VBA.
You mean you want to tell a user when he/she is entering a number in a cell that is >=1200?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
sorry for the confusion. I need a message to display if there are any numbers = or > 1200. I want users to still be able to enter them into the cell but i want some type of flag to display for me. Now i've already done conditional formatting but the list of clients is so freakin huge that i don't want to take the time to search through every entry. thats why i'm asking for a message to display. then i can just find and see which client is => then that number
Without VBA you won't get a "Pop up" message, but you can get any blank cell to show an alert message...
Something like: =IF(Countif(A:C,">=1200"),"An Entry Over 1200 Detected","")
This will show the message if any cell within columns A to C have a number greater than or equal to 1200.
Will that work.
Thanks alot man, this will work great!!
P.S. is VBA hard to learn or does it take a long time. like years or months.
Learning VBA is like learning any thing new
A lot depends on your own abilities to learn new things
How much time and effort you want to put into it & why you want to learn VBA (What you will use it for)
Creating forms, maniulting data requires fairly basic knowledge
Interacting with other programs & websites will require more advanced skills
You can learn many basic things quickly.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assisted or failed to assist you I welcome your Feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks