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?

Thanks

Answers


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

Need Your Help

C# numeric constants

c# casting

I have the following C# code: