wilg
12-01-2011, 03:04 PM
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")
ActiveCell.Value = Range("a2").Value & " FISCAL " & InputBox("Key Fiscal")