The key word is "opportunity" here.

You need to define the rules exactly.

You already have some code that is very close to being runnable. What
happens when you run it? What does/doesn't it do that you want to do?

So it takes them to the cell  and tells them to enter  it... but doesn't
stop them from moving on without entering data.

I think I understand what you are wanting. It seems like a real pain
for a User that enters a value in column  W and then selects a new Row
with no intention of entering more data. Would it help too for your
code to verify other fields in the same row? If the whole row  is
empty then column W shouldn't matter, right?

Anyways, here is something I put together to fulfill what I think you
asked for.

Dim trg As Long

Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If trg = 0 Then
trg = Target.Row
End If

'trg helps compare the new row selected with the previous row used
If (trg <> Target.Row And Cells(trg, 23) = "") Then
Cells(trg, 23).Select
MsgBox ("You must enter  a value in Column W")
Else
trg = Target.Row
End If

End Sub

That sounds like what your code will do. Is that what you want to do? If
so, where are you having trouble?

If not, then what do you actually want to do?