Hi!
I got problems to make macros for specific task. I'm new to VBA so it's very complicated for me. Please help!
Here is the picture for my task to better understand
Macros.jpg
1)In the Type collumn must be allowed only three values - "Meal","Income","Educat" and it needs to pop out warning if other values are entered(Warning 3)
2)"Income" must be allowed only if there is entered value in Income collumn and "Educat" and "Meal" must be allowed only if there is entered value in Expense collumn. Also there needs to be warning in both cases.(Warning 1)
3)Value can be allowed in Type collumn only if there is no value set in Subtype collumn. And warning of course(Warning 2).
I've searched the web with no results![]()
Bookmarks