Need a inputs to solve the scenario in VBA of Data Validation List?

**BhuvanRam** · 01-22-2012, 05:36 AM

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?

**royUK** · 01-22-2012, 05:47 AM

What kind of drop down list are you using?

**dilipandey** · 01-22-2012, 06:07 AM

Hi BhuvanRam,

See the attached file where I have a data validation list (as suggested by you) in sheet 1, cell a1 and when you select any of the item in this list, the value transfers to Sheet 2.
To view the code, press Alt + F11 from Excel window and double click on sheet1.

Regards,
DILIPandey

<click on below 'star' if this helps>

**BhuvanRam** · 01-22-2012, 10:11 AM

Hi Dilipandey,

Thanks a lot, and i understood from your sheet is that for every selection in data list refreshes the worksheet...

**dilipandey** · 01-22-2012, 11:07 AM

You are welcome BhuvanRam...

It can be same sheet as well but I believe you need to send a sample file with all the possible scenarios to explain what you are looking for. Thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>