View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
munchkin munchkin is offline
external usenet poster
 
Posts: 57
Default Input Box Cancel function

My input box works great when a user is filling in the info. But I also want
to give them the option to press cancel if they made a mistake & don't want
to proceed. If they press cancel I want Row 4 to be deleted & the macro to
end. How to I do that?


Range("B4") = InputBox("ENTER YOUR NAME - Press 'Enter' when done")
Range("C4") = InputBox("ENTER THE DATE YOU NEED THE FILE BY - Press
'Enter' when done")

Range("B4").Select