Alpha numeric with max 3 digit numbers based on criteria

hi,

I need to convert the target cell value with Alpha numeric based on multiple cell criteria. Following is the criteria

If Column A consists of Value "Float" and Column B consists value ("ABC") then convert target cell (Column C) with Alpha numeric.

Example,

If I enter value "1" in column C, then target cell value should be FDTJ-001

I have more than 14 criteria in Column B. I have attached the workbook with some samples.

Regards,

If Column A contains something else, then exit sub

Thanks, but I prefer a sheet event code. When I enter any number from 1 to 999 in target cell, it should convert to the desired format in the same cell based on the criteria. It does not limit to only one number.

Thanks, Is there any possibility to limit the number up to 3 digits only.

Dear Robert,

Your code does not change the Alphabet, it is giving the same text to whatever number I enter.

As an easy starter :

PHP Code: 

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 3 And IsNumeric(Target.Value) Then
        If Target(1, -1).Value = "Float" Then
            Select Case Target(1, 0).Value
                   Case "ABC":  V = """FDFT-""000"
                   Case "DEF":  V = """FDAJ-""000"
                   Case "DHI":  V = """FDDJ-""000"
                   Case "XYZ":  V = """FDRJ-""000"
            End Select
            If V > "" Then
                Application.EnableEvents = False
                Target.Value = Format(Target.Value, V)
                Application.EnableEvents = True
            End If
        End If
    End If
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

Thanks, this is exactly what I wanted. This the best and simple solution. Now I mark this thread as Solved.

Thanks for the rep' !