It's been a while since I've used VBA. How do I do a
comparison with a financial value?

I have the following, but no matter what the value
of the cell this puts a 1 into the active cell.

If ActiveCell.Offset(0, -1).Value "$10,000" Then
ActiveCell.Value = 1
End If

But, no matter what the value of the
ActiveCell.Offset(0, -1).Value
this puts a 1 into the active cell, when I only want a 1
when the ActiveCell.Offset(0, -1).Value is $10,000

Thanks,

Norm

How do I do a VBA comparison to a financial value (i.e. $10000)