worksheet change event

[Av8tordude]

I'm using the code below to change the font colors of cells that have constant values (works well). However, I notice the code triggers a worksheet change event, which I'm puzzled as to why this code triggers a worksheet change event?

Cells(ActiveCell.Row, 20).Resize(, 49).SpecialCells(xlConstants).Font.Color = RGB(14, 33, 56)

 

[jasonb75]

That line will not trigger a change event, what else is in the same procedure?

 

[Av8tordude]

I step debugged through the code and sure enough, its trriggering it... the rest of the code. I added the application.enableevents to stop the trigger.

If cbEnter.Caption = "Enter" Then
    Application.EnableEvents = False
    If Wks.Shapes("Position").TextFrame.Characters.Text = "Dark" Then
        Cells(ActiveCell.Row, 20).Resize(, 49).SpecialCells(xlConstants).Font.Color = RGB(14, 33, 56)
    Else
        Cells(ActiveCell.Row, 20).Resize(, 49).SpecialCells(xlConstants).Font.Color = RGB(255, 255, 255)
    End If
    Application.EnableEvents = True
    MsgBox "Transaction Recorded!", vbInformation

 

[Fluff]

That does trigger a change event for me, are you sure it's that line?

 

[Fluff]

Because of this line

Application.EnableEvents = False

that line cannot trigger the change event.

 

[jasonb75]

When you step through, does it switch to the change_event after the line that you say, or at a different point?

 

[Av8tordude]

I just did another entry from my userform to enter the data in the sheet. I started to debug at if cbEnter.Caption = "Enter" and step through it and as soon as it came across
Cells(ActiveCell.Row, 20).Resize(, 49).SpecialCells(xlConstants).Font.Color = RGB(255, 255, 255), it switch to the worksheet change event. (this is without the enable events)

 

[Av8tordude]

I mis-spoke. It was triggering a worksheet selection event (not worksheet change event)..sorry.

Anywas, why?

 

[Fluff]

That line will not trigger a selection change either (with or without disabling events)

 

[Joe4]

I mis-spoke. It was triggering a worksheet selection event (not worksheet change event)..sorry.

Anywas, why?

If you step through your code line-by-line, using the F8 key, you can see exactly when it jumps to your Worksheet_SelectionChange event procedure.
Make note of the last line of code run before it goes to the Worksheet_SelectionChange event procedure.
That is the line of code that is triggering it.