Thread
:
Input Box - CANCEL
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Danny
external usenet poster
Posts: 148
Input Box - CANCEL
Hi,
Please edit the macro below so when the user clicks on CANCEL or CLOSE the
box, Range A1 existing input won't change.
Sub InputNumber()
Range("A1").Value = InputBox("What is the number?")
End Sub
Thank you.
Reply With Quote
Danny
View Public Profile
Find all posts by Danny