Data validation want to select 1st in list using vba

[Syedali]

Hi Frds,

I have around 50 excel files, In a cell (example cell A2) i have data validation. Cell A2 i want to select 1st list in data validation using macro..

Thanks in Advance.
__________________________________________________________________

Mod edit : thread moved to appropriate forum !​

 

[Syedali]

Hi Friends,

Any advice on above query.

Hello genius @Hui am expecting from you.