Event target range

[Rasm]

Below is example of what I use - I keep all my default settings in a sheet where the operator can toggle between valid selections for a given variable. In this example what delimiter is used in ASCII files that can be imported, parsed and killed

This just part of code --- so add the rest as you see fit

Hope this helps

Thanks Rasm

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
    If Target.Column = 3 Then
        With ActiveSheet
             If .Cells(Target.Row, 1).Value = "FileDelimiter" Then
                If .Cells(Target.Row, Target.Column).Value = "CSV" Then
                        .Cells(Target.Row, Target.Column).Value = "TAB"
                    Else
                        .Cells(Target.Row, Target.Column).Value = "CSV"
                End If
            End If
     End With