VBA Less than formula

[Legacy 452653]

I have a warehouse mod to be completed and ive created automatic or Userform activate that when a order line is in the negative it needs to be highlighted in Reg

The formula I got is:
Private Sub Reg6_Change()
If Sheet12.Range("H6").Value < Sheet12.Range("K6").Value = "0" Then
Me.Reg6.BackColor = vbRed
Else
Me.Reg6.BackColor = vbYellow
End If
End Sub

So Cell H6 is the cell QTY ordered = 3 but in in cell K6 (Instock) = -1 because the TAB reference SUMIF indicates there is 2 in stock.

In the VBA I wanted the code to reflect Reg6 (TextBox) if cell K6 is less than ZERO please conditional format highlight in RED

It doesnt seem to work at all in either greater than so if anybody can help me out that would be great

Steve

 

[6StringJazzer]

The syntax on your If line doesn't make sense for what you are doing. Where does the zero come into play?

"when a order line is in the negative" What data here represents the "order line"?

This line will highlight red if H6 is less than K6:

If Sheet12.Range("H6").Value < Sheet12.Range("K6").Value Then

Other than that I can't quite tell what you want to do.

 

[Legacy 452653]

Oh yeah your right!
I thought I needed to tell VBA anything below ZERO please list this as red

So thank for that ….I feel such a dork!

Steve

 

[6StringJazzer]

I am still not clear on the logic you want to use. Your original question said "order line is in the negative" and "if cell K6 is less than ZERO" but you are testing for H6 < K6. If you need to test for K6 < 0 then

If Sheet12.Range("K6").Value < 0 Then

You didn't really give the whole picture here but it sounds like you have an order quantity, and an in-stock quantity. When the order quantity is entered, the in-stock quantity is updated by a formula on your worksheet. Therefore, if the in-stock quantity is negative, it means the order quantity exceeds current stock, and you want to highlight the textbox in red.

If that description isn't right then you probably need different code.