I'm needing to be able to display a message box dependent on a column-value. I have a 'verification' column that contains true/false values and a corresponding 'name' column. I want to be able to display a message box notifying the user of the names that have FALSE verification.
Example setup:
NAME VERIFIED
Steve TRUE
George FALSE
Bob FALSE
A message box is needed to let the user know that George and Bob need verification.
I assume a FindAll method could be used, but need further direction on how to accomplish my goal with VBA.
Example setup:
NAME VERIFIED
Steve TRUE
George FALSE
Bob FALSE
A message box is needed to let the user know that George and Bob need verification.
I assume a FindAll method could be used, but need further direction on how to accomplish my goal with VBA.