Cells checking for changes error

[grabrail]

Hi

I have a bit of code that monitors specific cells for changes, and if the entry of DF is entered, a form opens up for them to fill in some details.

I also have a button they can press that can set those cells to "N/A" if the data for the particular check they are doing isnt applicable

When I click the button to make all the cells required as N/A, including the cells being monitored for DF, I get a type mismatch error and the line of code below that include "DF" is highlighted. Available options for these cells are DF, NDF and N/A, why would i get the type mismatch error when the value of the cell is being set to N/A?

  ElseIf Not Intersect(Target, Range("M43:M48, M51:M54, M56:m59")) Is Nothing Then
        
            If Target.Value = "DF" Then
            
                tyres.Show
                
            End If

 

[Peter_SSs]

Most likely the problem is that when you press that other button to enter the "N/A" values it is triggering this code and when it gets to the problem line, it cannot do Target.Value because Target has 14 values.

A couple of possible solutions
1. In your "N/A" button code, set Application.EnableEvents = False at the start (& reset to True at the end) so that this code does not get triggered when you press the button
2. In this code at the start check if Target.Count > 1 and if so skip this code

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

 

[grabrail]

Most likely the problem is that when you press that other button to enter the "N/A" values it is triggering this code and when it gets to the problem line, it cannot do Target.Value because Target has 14 values.

A couple of possible solutions
1. In your "N/A" button code, set Application.EnableEvents = False at the start (& reset to True at the end) so that this code does not get triggered when you press the button
2. In this code at the start check if Target.Count > 1 and if so skip this code

BTW, I suggest that you update your Account details (click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Perfect thank you, I used option 1 and does the trick.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.

.. and don't forget the last paragraph in my previous post.

 

[Peter_SSs]

.. and don't forget the last paragraph in my previous post.

Thanks for making that change.