I have a problem I created and am not sure if it is even possible to accomplish what I am trying.
I have one function of my workbook putting activated by a button macro that goes into a series of inputbox arguments.
Big problem is, if the information does not need updating, is there away to tell the result to leave the data the InputBox is pointing to?
The argument so far is as follows:
I have one function of my workbook putting activated by a button macro that goes into a series of inputbox arguments.
Big problem is, if the information does not need updating, is there away to tell the result to leave the data the InputBox is pointing to?
The argument so far is as follows:
Code:
Sub LotBt()
Dim FilenametxtA, Filenametxt1 As Object
Dim a As Variant
FilenametxtA = InputBox("Please Enter the Run Date for the Assays")
If FilenametxtA <> "" Then Sheets(RUN_setup)(N20).Value = Sheets(RUN_setup)(N20)
Range("N20").Value = FilenametxtA
Filenametxt1 = InputBox("Please Enter Kit Lot Number below")
If Not Filenametxt1 <> "" Then Range("p23").Value = Range("p23")
End If
End Sub<strike></strike>