perhaps you don't know *where* to
put the code in order to get the code to execute in order to sign  to
change.

You can put the code inside the SelectionChange (or the Change)
event that belongs to the sheet the data is in. Then, when a number
is entered and the Enter key pushed, this Sub will fire and the sign
can be changed with the code.

In the VB editor, select the sheet, then select Worksheet in the
left Object PullDown on the top left. The followinag should appear
automatically. If it does not, select it in the upper right Procedure
PullDown.

Option Explicit
.................................................
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
' Put the sign change  code here
End Sub
.............................................