yogeshwarv
11-23-2005, 06:46 AM
Hello Sir,
I am stuck with a problem with the list function with validation properties. I have applied list command in cell "A2" but it is showing duplicate records also, I wish if the dropdown list menu could display the unique entries only. And in alphbetical order. Is it possible with the help of VBA, if yes Knidly help me out. An urgent reply will be extremely appreciated.
I have enclosed the sample file for better explanation.
Please Help!!!!!!!!!
I am stuck with a problem with the list function with validation properties. I have applied list command in cell "A2" but it is showing duplicate records also, I wish if the dropdown list menu could display the unique entries only. And in alphbetical order. Is it possible with the help of VBA, if yes Knidly help me out. An urgent reply will be extremely appreciated.
I have enclosed the sample file for better explanation.
Please Help!!!!!!!!!