VBA commands for multiple cells?

**JLoKyM** · 08-27-2013, 09:14 AM

Hello, I'm a complete amateur in VBA so my question may be stupid but I really don't know how to resolve my problem. So, I have an excel table with multiple drop-down lists. However for certain cells, I'd like to have multiple options choice so I've modified to following code to work for me. The problem is that it works only for one cell and I want it to work for multiple cells but not all: For example; I want to have this multiple choice drop down lists in cells D8, D13, D18 and D21. Can you help me with that please

)

Here's the code I'm using.

HTML Code:

**JLoKyM** · 08-28-2013, 04:54 AM

So no one knows the answer to my question?

**Debraj Roy** · 08-28-2013, 05:26 AM

Hi JLoKyM..

Please use code tag for Codes.. otherwise it really hard to read.. and you may also get an idea that.. "No One knows the answer.."

BTW.. try this..

Please Login or Register  to view this content.

**JLoKyM** · 08-28-2013, 05:34 AM

Hi, sorry about not using code tag. it's fixed now.

I've tried your idea but I get the following error: Compile Error: End if without block if.
And I don't know whether this is important but the first line: Private Sub Worksheet_Change(ByVal Target As Range) becomes in yellow.

**Debraj Roy** · 08-28-2013, 05:50 AM

I din't found any error in my code.. and working fine.. for me..
All IF blocked are closed..

Right click Sheet name, where dropdown Data Validation exists.. then..
paste code in the same module..
Dont use the code in New Module..

I know you are pasting the code in Sheet module only, as Worksheet_Change event triggered and highlighted with Yellow.. still for precaution..