LinkBack URL
About LinkBacks
How do I automatically change a number in a cell (F4) to a negative number if the text in another cell (C4) is "Credit." Is this possible without having to manually put the negative sign every time I enter a number in the Credit category? Thanks!
How do I automatically change a number in a cell (F4) to a negative number if the text in another cell (C4) is "Credit." Is this possible without having to manually put the negative sign every time I enter a number in the Credit category? Thanks!
If you are manually entering the values, I think you will just have to use that 1 extra key-stroke for the -
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
I see. I'm just wondering since I'm sharing the workbook (household budget) with someone who might forget to enter that 1 extra key-stroke. It's okay, I just have to double check the entries. Thank you though.
Another option might be to have 2 columns - 1 for income, the other for expenses?
Or
Copy the below code and do right click on sheet tab and select view code and paste the below code. Return to excel and check it by doing entry in Column-F
Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("F:F")) Is Nothing Then Exit Sub Application.EnableEvents = False If InStr(1, Target.Offset(, -3).Value, "Credit", vbTextCompare) Then Target.Value = -Target.Value Application.EnableEvents = True End Sub
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks