Thread: Input Box
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
steven steven is offline
external usenet poster
 
Posts: 389
Default Input Box

If I do this:

If Response1 = vbYes Then
SaveUserName = InputBox("Enter User Name:")
Range("RangeUserName") = "User: " + SaveUserName
End If

How do I catch if the Cancel button was pressed and therefore don't do
anything?

Thank you for your help.

Steven.