Results 1 to 7 of 7

Inputbox cancel button error.

Threaded View

  1. #1
    abhay_547
    Guest

    Inputbox cancel button error.

    Hi All,

    I have the below code which I use to get some input from the user using input box when the user clicks on the cancel button it shows an error.

    Dim W As Long, H As Long, ws As Worksheet
    
    W = InputBox("Enter chart width", "Set Chart Width", 100)
    
    
    H = InputBox("Enter chart height", "Set Chart Height", 75)
    I tried to use below but still the user faces the error. Please help.

    If W = "" Then Exit Sub
    Thanks a lot for your help in advance.
    Last edited by abhay_547; 11-05-2010 at 06:31 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1