VBA Code in Excel to Substitue
I know this should be simple but i cannot get it to work.
In a particular range of cells, E15:E30 for example, whenever a person types a comma i want excel to substitute the , with a +
What should my VBA code look like?
Place this block of code in the Worksheet code page you want it to be active on in the VBA editor.
Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Range("E15:E30"), Target) Is Nothing And Target.Cells.Count = 1 Then Target.Replace ",", "+" End If End Sub