Problem with multiple-select Drop down list|VBA & Macros|Excel Forum|My Online Training Hub

Hi Tammy,

I'm not sure what you mean by i got some problems the first one is: when i use codes for another thing

Can you provide the file you are using and explain what you are trying to do?

The purpose of this code

If Target.Count > 1 Then Exit Sub

Prevent the code running of more than 1 cell is being changed at the same time.  If you are using a drop down data validation list, then you should only ever be changing 1 cell at any time, so there's no need to remove that line.

If Target.Value = "" Then Exit Sub

If the cell value has been deleted, then exit the code, there's no need to run anything.  If you have deleted this line, that is why you are finding that the code doesn't run when you delete the cell contents.

If what you are trying to do is run the code for 2 different data validation lists then you need to change this line to account for the 2nd dv range

If Not Intersect(Target, ActiveSheet.Range("DV_Range")) Is Nothing Then

If you can supply your file and explain exactly what it is you want to do, I'll see if I can come up with a solution.

Regards

Phil

Hi Tamara,

You need to add a 'trap' to check for the cell that is being changed.  As you want to check the value in C6 when it is changed, you need to add code to check for a change to that cell, like this

If Not Intersect(Target, ActiveSheet.Range("C6")) Is Nothing Then

If Range("C6") = "yes" Then

[9:11].EntireRow.Hidden = False

Else

[9:11].EntireRow.Hidden = True

End If

End If

See attached file.

Regards

Phil

Hi Tamara,

Running the code in the last file you provided does not generate any errors.

Could you please describe in detail exactly what it is you are trying to do.  Maybe provide a file or an image showing an example of the final result you want.

Since your initial request, you've described a number of different issues, which i have resolved, but I'm still not clear what it is you are actually trying to do.

Regards

Phil

OK I think I know what you mean.  The code you've entered is interfering with my code that checks the selection from the validation list.

You just need to move this after my code so the DV changes are dealt with correctly, then your code can run doing what you want.

If you stepped through the code you could see that this was happening.  Please read these posts which discuss debugging VBA code:

Debugging VBA Code

More Tips for Debugging VBA Code

regards

Phil