Data Validation with overwrite input box prompt

[LORDMARKS]

Hi All

I am not sure if this is possible, but thought I would ask.

On a large workbook I have a column with drop down data validation of "Job position" I would like a way of adding a "name" only if one "Job position" is selected. I am not sure what is the best way of approaching this, I looked at just adding a new column, but due to the number of sheets, calculations, and links to other files, it would be a massive job.

My thinking was to monitor cell via VBA somehow, then if value selected, provide input box and replace cell contents with the input box value?

Any suggestions would be greatly appreciated<o></o>

 

[LORDMARKS]

If anyone is interested, I found this online and adapted. Works perfectly

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "F21:F1001"
    On Error GoTo ws_exit
    Application.EnableEvents = False
    Application.ScreenUpdating = False
    
    If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
        With Target
        
            If Target = ("MAINTENANCE TECH") Then
            Imput = InputBox("PLEASE ENTER THE TECHNICIANS NAME")
            Target = ("TECHNICIAN ") & Imput
            If Imput = "" Then Target = ""
            Else
        End If
        End With
    End If
ws_exit:
    Application.EnableEvents = True
    Application.ScreenUpdating = True
End Sub

I would give credit, but i had that many trials on the go, I cant remeber where it came form. sorry