inputbox cancel

[wilg]

I have below code for an input but value, but if inputbox is x'd or cancel selected it put's in no value deleting what was in there. Can this be modified to leave current value if inputbox is closed or cancel selected?


ActiveCell.Value = Range("a2").Value & " FISCAL " & InputBox("Key Fiscal")

[wilg]

with this as well, is there a way to run the inputbox with the current cell value already entered into the input box & selected?

[mdmackillop]

txt = InputBox("Key Fiscal", , ActiveCell)
If txt <> "" Then
ActiveCell.Value = Range("a2").Value & " FISCAL " & txt
End If

[wilg]

Thank you. Works