Macro for dropdown list in Excel

**Tulsi** · 04-28-2009, 01:43 AM

Hello,

Could somebody give me a macro for copying a particular value from a dropdown list into a next column.

For example:

If I select "1" (from the dropdown list) then paste "1" to next column(same row)
If I select "2" (from the dropdown list) paste "2" to next column(same row) on deleting the previously selected option (i.e, "1")

Please help me in writing this Macro.
Thanks

**martindwilson** · 04-28-2009, 09:19 AM

why do you need to do this?. it seems a fairly pointless excercise.

**Paul** · 04-28-2009, 10:03 PM

I assume you're using a Data Validation drop-down list? If so, and that is in cell A1, then in B1 simply put =A1

Whenever you change A1, B1 will be updated.

**Tulsi** · 04-29-2009, 04:52 AM

Thanks a lot pjoaquin. It helped me!!

I have another issue with the same sheet.
My dropdown list contains the options like "1,2,3,4,5,6,7, Invalid" (say cell B4)

"Invalid" is also one of the option.

1.If the user select numbers 1,2,3,4,5,6,7(from cell B4) that numbers gets copied to next cell say D4.I have implemented this by using "=B4" in D4

2.If a user selects "Invalid" from the list, user should be able to enter a value (number, character, string, special character) in the corresponding cell next to the dropdown(i.e in D4). how do i implement this?

Please help me in this .

**martindwilson** · 04-29-2009, 05:16 AM

now you are explaining yourself it makes a bit of sense. you cant overwrite a formula without changing it so you would need code to do it like that.or perhaps something like this. try the options in the drop down in b4