Using If Else to return vlaue other than 0 when an inputbox is canceled

[jordanl]

Hi,
I have an inputbox that sets a public variable and uses if...else to change that value if one has already been set. What I'd like to do is when the user runs the sub when a value has already been set and clicks cancel rather than entering a new value, the value stays as it is rather than gets switch to 0 (or false, or whatever canceling an inputbox does). Here's the sub as it is now:

Public HldWrkBk As String
Sub HoldWrkBk()
    If HldWrkBk = "" Then
        HldWrkBk = InputBox("Enter Holding Workbook")
    Else
        HldWrkBk = InputBox(HldWrkBk, "Enter New Holding Workbook")
    End If
End Sub

Thanks!!!

 

[Norie]

I think you'll need another variable to store the result from the input box.

 

[jordanl]

I think I figured out a way to do what I need:

Sub HoldWrkBk()
    If HldWrkBk = "" Then
        HldWrkBk = InputBox("Enter a Holding Workbook")
    Else
        HldWrkBk = InputBox("Enter a new Holding Workbook or click okay to continue with the current workbook", , HldWrkBk)
    End If
End Sub

This way, it uses the current variable as the default text so if you click okay, it just reenters it.