AW: Bindesstrich nach bestimmtem Buchstaben
27.01.2018 10:57:25
Sepp
Hallo Alexander,
in das Mosul der Tabelle.
' **********************************************************************
' Modul: Tabelle1 Typ: Element der Mappe(Sheet, Workbook, ...)
' **********************************************************************
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
Dim objRng As Range
On Error GoTo Errorhandler
Application.EnableEvents = False
If Not Intersect(Target, Range("A2:A100")) Is Nothing Then
For Each objRng In Intersect(Target, Range("A2:A100"))
If InStr(1, objRng, "-") = 0 Then
If Left(objRng, 1) Like "[D,F,G]" And Len(objRng) > 1 Then
objRng = Left(objRng, 1) & "-" & Mid(objRng, 2)
ElseIf Not Left(objRng, 1) Like "[D,F,G]" And Len(objRng) > 2 Then
objRng = Left(objRng, 2) & "-" & Mid(objRng, 3)
End If
End If
Next
End If
Errorhandler:
Application.EnableEvents = True
End Sub
Gruß Sepp