Create Plus Minus Switch @Exceltrainingvideos
Create Plus Minus Switch  @Exceltrainingvideos
Uploaded November 2019 | Updated November 2026, 13 hours ago
How to create a plus minus switch to convert positive numbers to negative and negative numbers to positive numbers automatically without converting dates and numbers obtained via formulas using VBA.
Here's the complete VBA code:

Sub PlusMinusConverter()
Dim cel As Range

On Error Resume Next
For Each cel In Selection
If Not cel.HasFormula Then cel.Value = -cel.Value
Next cel
End Sub
Create Plus Minus SwitchCalculate Change Percentage Automatically as you TypeAutomatically Send Message with Image Via WhatsappSuper Quick Method to UNSTACK One Column of Data into Multiple ColumnsCreate Dynamic User Form with two Dependent Combo BoxesRemove Blank RowsCreate Interactive ChecklistSuper Easy Secure Data Entry FormDisplay List of All Files in folder in Combo BoxXlookup functionCreate Multiple Slicers Using Table Data AutomaticallyAnimations for User Interfaces
Dinesh Kumar Takyar |

Create Plus Minus Switch

SHARE TO X SHARE TO REDDIT SHARE TO FACEBOOK WALLPAPER