Before running code comment out another code

[ipbr21054]

Not sure if i title is correct.

I think its called comment out. Its when the code doesnt run as you put a marker at the front of the code ??

I have a code which as the user works the row they are on changes to Blue & the Cell they are in Green,all the other cells are Yellow until selected etc.

I wish to use a code that will change the cell color when i type in a value to look for.
Textbox or input filed im not sure yet but say i type TOM the code will look withing my range for TOM & change cell color to a color of my choice.
Before i run this code can we comment out the other code using vba ?
The other code being,
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

Just saves the user going into the page & doing it manually of which i dont want them to

 

[Micron]

Before i run this code can we comment out the other code using vba

No. Your code needs to handle every scenario that you can imagine (and eventually those you did not). Often that is done with IF or Select Case blocks (IF statements or Select Case statements that test for certain conditions and act accordingly).