I am trying to creat a pop-up warning via VBA in the attached file.
In the attached file,
If the type is "training" and Team is selected, show a pop-up warning to leave the Team blank
If the type is "work" and the team column is blank, show a pop-up warning to select the Team
highlighted cells are incorrect in this example
Hi kebede,
When should the pop up show up? is the Team column supposed to be filled first, and then if Type does not match, the warning comes up? Easy to give a message, the question is what is the filling order, and what triggers the check.
Please help by:
Marking threads as closed once your issue is resolved. How? The Thread Tools at the top
Any reputation (*) points appreciated. Not just by me, but by all those helping, so if you found someone's input useful, please take a second to click the * at the bottom left to let them know
There are 10 kinds of people in this world... those who understand binary, and those who don't.
yes, the Team column is supposed to be filled first. so, if Test 3 selected "Marketing" and picked "training"-there should be a warning. and If Test 4 left the team blank and selected anything but "training", there should be a warning. in other words, the Team column should remain blank, every time a test/employee is training and filled in if working.
Employee Team Type
Test 3 Marketing training
Test 4 work
In the VBA editor, double click on Sheet1 in the project window, and add this code:
Or I've attached your file with the modifications.
Please Login or Register to view this content.
Hey Arkadi, thank you so much for your help on this.
When I delete filled in cells, I get the "Run-time error '13':
How do I prevent that when the cell value is cleared?
Last edited by kebede; 07-27-2023 at 02:04 PM.
Not sure you can detect that it is a deletion... and this solution would also mask other issues, but in theory at least this will ignore the error (whatever it is)
Please Login or Register to view this content.
Better option:
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks