Private Sub Workbook_SheetBeforeDoubleClick(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)
Dim C As Range
Dim Response As String
If Target.Row <= 6 Then Exit Sub
If Target.Column = 1 Then
Application.EnableEvents = False
Response = UCase(InputBox("Please enter the line and batch.", "QA", "9" & Format(Date - DateSerial(Year(Date), 1, 0), "000") & "1092 - "))
ActiveCell.Offset(0, 1).Select
End If
Application.EnableEvents = True
End Sub
ActiveCell.Value = Response
SendKeys "{END}"
InvoiceNum = InputBox("Input Invoice Number", "Customer Name: " & addme, 55366)