Results 1 to 2 of 2

Thread: How to Activate

  1. #1

    Thread Starter
    Lively Member mykg4orce's Avatar
    Join Date
    Oct 2000
    Location
    CANADA
    Posts
    92

    Exclamation

    I am using a input box to ask quantity and saving it for a calculation. But i need to know how, what if the user clicks on cancel, how do I make the program end instead of giving an error message.

    temp = msgbox("blah", vbYesNo, "blah2")
    if temp = vbYes then
    end
    end if

    this works with msgboxes but not with inputboxes, is there a solution????

  2. #2
    Hyperactive Member
    Join Date
    May 2000
    Location
    Or
    Posts
    316
    Try this:

    Code:
    temp = InputBox("Enter Date here")
    If Len(Trim(temp)) = 0 Then  'make sure it just isn't white space
      End
    End If
    Hope this helps

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width