Edit VBA code for long list

Hi,

I have some exitsing VBA code from an old spreadsheet and had these instructions below to edit where the code worked to add the code to 3 more cells, does anyone know the code that I could use to make this work on multiples cells and starting from c10 down to c200.


This info below allows me to add to a few cells:-

Q: In the VBA code, the functionality is for cell C2 only. How do I get it for other cells?

Ans: To get this multiple selection drop-down in other cells, you need to modify the VBA code in the backend. Suppose you want to get this for C2, C3, and C4, you need to replace the following line in the code:

If Target.Address = "$C$2" Then

with this line:

If Target.Address = "$C$2" Or Target.Address = "$C$3" Or Target.Address = "$C$4" Then


Regards
Garry

HI,

Sincere apologises, I should have included a test file.

I am trying to edit this file so that I can have multiple selections from a drop down list but only work on a range of cells say C10:C200.

Garry

Many thanks, this now works, much appreciated.
Garry