Making cells negative depending on neighbor cell

[Vbanoob98]

Hi guys, I have the following code that adds a cell value based on finding a text "Total" in the row. Im stuck now trying to make it change a value to negative

Here is the code

Sub test()
 
myNum = Application.InputBox("Description")
LastRow = Range("C" & Rows.Count).End(xlUp).row

With Range("C2:C" & LastRow)


     Set c = .Find("*Total")
     If Not c Is Nothing Then
        firstAddress = c.Address
        Do
            c.Offset(0, -1).Value = 555
             c.Offset(0, -2).Value = 123
             c.Offset(0, 4).Value = myNum
             c.Offset(0, 0).Value = make numbe negative code goes here
c.Offset(0, ).Value = Code here to multiple the # * -1
            Set c = .FindNext(c)
        If c Is Nothing Then
            GoTo DoneFinding
        End If
        Loop While c.Address <> firstAddress
      End If
DoneFinding:
End With

End Sub

Here is the part Im trying to change

c.Offset(0, 0).Value = make value

 

[FatBoyClam]

What value are you trying to make the negative of?

c.Offset(0, 0) represents the cell you found the word "Total" in. Are you sure you want to replace that with a number?

Other than that - you appear to be on the right track, simply multiply the desired number by negative 1

For example, if you wanted the negative of the "myNum" variable, it'd be this;

             c.Offset(0, 4).Value = myNum*-1

If myNum is already negative, that'd produce the positive value. If you always wanted the negative value ( 5 becomes -5 and -5 stays -5) then it'd be this;

             c.Offset(0, 4).Value = ABS(myNum)*-1

 

[Yongle]

Offset is not required if Offset is ( 0, 0)
Value property is the default and therefore not required to be specified

This multiplies the number by -1

c = -c

If the cell should always contain a negative number

c = -Abs(c)

 

[Vbanoob98]

Sorry its supposed to be (0, 1) and its a cell thats already there

I tried

C.offset(0,1).value = cell.value * -1

But I get an error object requiered

 

[FatBoyClam]

"cell" is not a declared object.

You still haven't said what value you're trying to show the negative of.

In your example, you have this;

What is the value a negative of? 555? 123? myNum? One of the blanks?

 

[Vbanoob98]

Sorry, I was trying the solutions that were offered. I was just trying to convert numbers to negative. So I had a bunch of random totals 45557, 28373, etc

What I did was this:

C.offset(0, 1).value = -abs(c.offset(0, 1))

Thanks for all the help