Multiple validation selection

[maxthebear]

The code below lets me select more than one item in a column 14 dropdown and put them in the cell.

I am trying to let another column have the same properties. This time it is column 17. I tried adding another line but it doesn't work. Can anyone help with the code.

thanks Max

Please Login or Register  to view this content.

[JBeaucaire]

Without a sample of your sheet to test this on, just a shot in the dark:

Please Login or Register  to view this content.

[maxthebear]

Thanks for the responses.

I replaced the targetcolumn 14 code with your code. It gave me the following error

compile error:
Block if without end If

Any thoughts? Sounds like it is almost there. I'll try and get a sample but maybe the error can be fixed??

Max

[JBeaucaire]

ADD another "End If" just above END SUB at the bottom of the code.

[maxthebear]

That did the trick.. Very cool and thanks. I'm planning on getting some VBA help going forward so here is a question. I know Dim is short for Dimension but what do these three lines mean??

Please Login or Register  to view this content.

Again thanks a bu

[JBeaucaire]

Dim does mean "dimension" and it's a way of indicating something in short "named" form.

Dim NewVal as String - "NewVal" is the short name you're going to reference, and it is a string, a specific value at any given moment. Calling it a string here means you don't have to do that later in your code as you go.

Dim Rng as Range - "Rng" is the short name you're going to reference a whole range of cells by, and it is a range, so a specific value at any given moment will have to be identified.

Typically the way you'll do that is by a "cell" reference and point to its current value (cell.value) to get the "string" of the moment, possibly from within the Rng.

Hope that's helpful, I'm sure I'm understating some of this...

[maxthebear]

It helps. I'm sure when I get more involved it will come together. I can't thank you and everyone involved with this site. It's a life saver. I'll mark it solved and go the ratings section.................Again thanks......

Max