When I press cancel, puts zero (0) by default

[tvlatko]

I’m working on a financial model in excel. I have this pop-up window whenever I open one of the percentage rates. It asks what year do I won’t to work on. The problem is if I press cancel it puts 0 value instead of just having the values that are there.

Here is the code in visual basic.
What changes should I make?

ElseIf btnEnterYears.Value = True Then
Sheets(“Workbook Map”).Activate
Range(“CURRYR”).Select
ActiveCell.Value= Val(InputBox(“Enter the Base Year.”,”Base Year”))
ActiveCell.Offset(1,0).Select
Range(“A1”).Select

Thanks in advance,
vladimir

 

[Abaka]

What about this way: put code under keypres event and
.....(your code)
if Keyascii =27 then
exit sub

 

[JustinEzequiel]

dim inputVal as string

inputVal=InputBox(“Enter the Base Year.”,”Base Year”)
' StrPtr(inputVal)=0 if cancel was clicked
if StrPtr(inputVal)<>0 then
ActiveCell.Value= Val(inputVal)
end if