VBA - Select multiple columns

[PIP7410]

Hi all...please help! I'm new to the wonderful world of VBA
I have a spreadsheet with many pick lists. Some of these should only allow a single item to be selected, some should permit multiples.

I have the code to allow multiples to be selected, and have got it working so that it selects a single column only. Problem is, I need to it allow multiples in 3 columns, but not the rest. Any help would be appreciated! At present I need it to allow multiples on columns 11, 12 and 13, but can only get it working on a single row (11).

oldVal = Target.Value
Target.Value = newVal
If Target.Column = 11 Then
If oldVal = "" Then
'do nothing
Else

Thank you in advance!

 

[Rick Rothstein]

Hi all...please help! I'm new to the wonderful world of VBA
I have a spreadsheet with many pick lists. Some of these should only allow a single item to be selected, some should permit multiples.

I have the code to allow multiples to be selected, and have got it working so that it selects a single column only. Problem is, I need to it allow multiples in 3 columns, but not the rest. Any help would be appreciated! At present I need it to allow multiples on columns 11, 12 and 13, but can only get it working on a single row (11).

oldVal = Target.Value
Target.Value = newVal
If Target.Column = 11 Then
If oldVal = "" Then
'do nothing
Else

For continuous columns (like you asked for), try this If..Then line of code...

If Target.Column>10 And Target.Column < 14 Then

 

[PIP7410]

Hi Rick - perfect, thank you so much!