I have the sheet code below and I am wondering if it is possible to be able to let the user enter more than one Job Template Number using some sort of separator
Code:
Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
Dim strCellName As String
Dim strReplace As String
strCellName = Target.Value
If InStr(1, strCellName, "@Para1") > 0 Then
strReplace = InputBox("Job Template Number OR % (Wildcard)")
If strReplace = "" Then
Cancel = True
Exit Sub
End If
strCellName = Replace(strCellName, "@Para1", strReplace)
End Sub