I have 3 columns
Column A= Status (values are Open and Closed)
Column B = List 1 (values=a series of RootCause values to choose from)
Column C = List 2 (values = a series of Sub Root Cause values which appear based on the Column B selected value)
Column C is a dependent drop down list to Column B. Both tables used in the drop down lists are tables and reference Defined Names.
I want Column B to be a required value ONLY if Column A = Closed. if Column A <> Closed, Column B is not required.
(Col B Values can be grayed out, left visible or another message can display. The key is Column B being required if Column A = Closed. This is to prevent a user from missing to fill in Column B.)
Similarly I want to make Column C required if Column B is not blank or null.
How do I add this to VB Code.
Because the drop down list is referencing the Defined Name as the "source" in the Data Validation tab, I cannot add a formula as the source and properly reference this Defined Name and have it successfully work. Therefore I thought to add VB code.
I am novice and need to know exactly what , where to add.
Column A= Status (values are Open and Closed)
Column B = List 1 (values=a series of RootCause values to choose from)
Column C = List 2 (values = a series of Sub Root Cause values which appear based on the Column B selected value)
Column C is a dependent drop down list to Column B. Both tables used in the drop down lists are tables and reference Defined Names.
I want Column B to be a required value ONLY if Column A = Closed. if Column A <> Closed, Column B is not required.
(Col B Values can be grayed out, left visible or another message can display. The key is Column B being required if Column A = Closed. This is to prevent a user from missing to fill in Column B.)
Similarly I want to make Column C required if Column B is not blank or null.
How do I add this to VB Code.
Because the drop down list is referencing the Defined Name as the "source" in the Data Validation tab, I cannot add a formula as the source and properly reference this Defined Name and have it successfully work. Therefore I thought to add VB code.
I am novice and need to know exactly what , where to add.
