Possible dynamic If statement in VBA?

I want to use if statement to evaluate 2 parameters among a plethora of conditions. I know I can use if statement with AND/OR but I think it will be visually cumbersome to do it in excel.

Is it possible to implement the if statement in VBA dynamically? Meaning I want to check the result of the If statement promptly while changing its conditions -say from a drop down list- in the excel sheet (Without having to open and run the VBA window).