Solved: Selection Change Event only if Row Selected Changes.

[frank_m]

Another problem I should know the answer to by now, but don't.

How do I avoid running the CreateRowCellsTextBoxes Macro if the selection change stays within the same row?

Thanks
[vba]Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not TheSameRow is Selected Then'<--Improper syntax to demonstrate my need
Call CreateRowCellsTextBoxes
End If

End Sub[/vba]

[Bob Phillips]

[vba]

Private prevRow As Long

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Target.Row <> prevRow Then '<--Improper syntax to demonstrate my need
Call CreateRowCellsTextBoxes
End If

prevRow = Target.Row
End Sub[/vba]

[frank_m]

Perfect

Thanks Bob