Worksheet Change + Call "Macro"

[andrefenti]

Hi everyone!

I have a code I am trying to run, but it keeps showing this message:

"Compile Error:

Invalid use of property"

_________________________
This is the code:

Sub Worksheet_Change(ByVal Target As Range)

If Target.Column = 12 Then
Sheets("Display TRT").Select
Call Comments
MsgBox "It worked"
End If
End Sub

________________________

"Comments" is a Sub that runs with no problems when I click on na option button.

I want this macro to run whenever I change any cell on the 12th column of the sheet.

When I take off the "Call Comments" line, the problem does not happen.

Does anyone know how I can fix this??


Att.,
André Fenti Yamamoto

 

[Joe4]

Welcome to the Board!

"Comments" is also a reserved word in VBA.
The problem with using reserved words, is Excel VBA cannot tell if you are trying to call the Subprocedure "Comments" or the Property/Method "Comments".

You want to avoid using Reserved words as the name of your procedures, functions, objects, and variables for this exact reason.
Change the Procedure name to something like "MyComments" and it will work (tested and verified).
When I code, I add this "My" prefix to any word that I think might possibly be a reserved word, just to be safe.

 

[My Aswer Is This]

You need to show us the Comments script code.

 

[andrefenti]

It worked!!!! Thank you very much!

welcome to the board!

"comments" is also a reserved word in vba.
The problem with using reserved words, is excel vba cannot tell if you are trying to call the subprocedure "comments" or the property/method "comments".

You want to avoid using reserved words as the name of your procedures, functions, objects, and variables for this exact reason.
Change the procedure name to something like "mycomments" and it will work (tested and verified).
When i code, i add this "my" prefix to any word that i think might possibly be a reserved word, just to be safe.

 

[Joe4]

You are welcome!
Glad I was able to help!