Potatoexcel
New Member
- Joined
- Mar 6, 2022
- Messages
- 1
- Office Version
- 2013
- Platform
- Windows
Hello, I need some help to solve a certain problem.
Let's say I have Value "a" and if it's belong to range from (a~b) or (c~d) etc then I want to activate all the functions in table A that corresponded to range (a~b) and deactivate the functions in the other tables.
If the Value "a" doesn't belong to any specify range then in another cell, it say "False" then end, all the tables are at deactivate status.
For context, the different tables contain evaluation condition depends on the Value of "a" and at the end give an evaluation at the end to be "OK" or "FALSE". This Evaluation affect the overall evaluation of the Sheet. That is why I need to create separate tables and deactivate them so they don't get in the way of the overall evaluation.
I am not very familiar with VBA so If possible I would appreciate if someone can write an example code for me to work with as well...
I also put a summary flow of my problem for visualization purpose. I hope it will help you get the gist of what I am saying.
Thank you very much.
Let's say I have Value "a" and if it's belong to range from (a~b) or (c~d) etc then I want to activate all the functions in table A that corresponded to range (a~b) and deactivate the functions in the other tables.
If the Value "a" doesn't belong to any specify range then in another cell, it say "False" then end, all the tables are at deactivate status.
For context, the different tables contain evaluation condition depends on the Value of "a" and at the end give an evaluation at the end to be "OK" or "FALSE". This Evaluation affect the overall evaluation of the Sheet. That is why I need to create separate tables and deactivate them so they don't get in the way of the overall evaluation.
I am not very familiar with VBA so If possible I would appreciate if someone can write an example code for me to work with as well...
I also put a summary flow of my problem for visualization purpose. I hope it will help you get the gist of what I am saying.
Thank you very much.