|
|
|
|
#1
07-24-2018, 11:01 AM
|
|||
|
|||
excel sheet code help
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
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| VBA code If... then... copy... from one sheet to another | Seiquo | Excel Programming | 2 | 06-28-2017 10:52 AM |
| VBA Newbie (Trying to write a code to copy and paste info from one sheet to another) | Forum2000s | Excel Programming | 2 | 05-07-2017 04:51 AM |
 How to copy excel sheet withe HEADER and Paste into new sheet?
|
cloudforgiven | Excel Programming | 6 | 01-05-2017 07:30 PM |
| VBA Code to Hide columns based on selection on prior sheet | Silver1379 | Excel Programming | 0 | 04-15-2015 08:40 AM |
|
Any tutorial same as to this excel sheet with code?
|
Learner7 | Excel | 1 | 05-18-2010 05:31 PM |
Windows 7 64bit 
Office 2010 64bit
Hybrid Mode