Hi,

Recently one of my superior called me and said me to solve the new scenario which is completely different to my subject(Dotnet). He said to create a Drop Down List in Excel. By googling i created a Simple Drop Down List. But the Questions is
1. He needs a drop down list as "Apple, Mango, Grapes". If the user selects Apple or Mango or Grapes it has to be copied to next sheet in any cell.

I am very new to VBA, my question is whether it can be achievable or not because i dont know that excel drop down list has selected event or not?. Frankly speaking as i am a programmer, i used to do Selected Event in C#.NET for Drop Down List. Could any one suggest me that how to do this? If possible any one post me a sample code or at least steps to do?