Determine the value from a Data Validation List in VBA

[OmarFKH]

Hello everyone ,
i have been trying to find a solution for my problem but it is really wierd because i found no solution.
so here is my problem : i have a whole column in which every cell have a Data validation list. So in Vba i am making a For loop to compare the value selected in those cells with another value in another worksheet . The BIG problem is that the cells with data validation list have no value in vba !
What should i do ?? i hope you find me a solution!

 

[Scott T]

If you selected a value from data validation drop down list then VBA should see that value. If you do not and only have a blank cell then VBA sees it as an empty cell. It would be helpful if you post your code.