Results 1 to 3 of 3

InputBox Cancellation

Threaded View

nms2130 InputBox Cancellation 06-29-2010, 10:33 AM
Bob Phillips Re: InputBox Cancellation 06-29-2010, 11:17 AM
Leith Ross Re: InputBox Cancellation 06-29-2010, 12:04 PM
  1. #1
    Registered User
    Join Date
    06-16-2008
    Location
    Arlington, VA
    MS-Off Ver
    2007
    Posts
    93

    InputBox Cancellation

    I am having trouble with the Range type of Input Box being cancelled. I am using the code below and upon cancel I receive an object required message.
    What am I doing wrong?

    Dim xnbrs As Range
    Set xnbrs = Application.InputBox(prompt:="Highlight Exhibit Numbers", Type:=8)
        If xnbrs Is Nothing Then
            Exit Sub
        Else
        For Each xnbr In xnbrs


    Thanks in advance
    Last edited by nms2130; 06-29-2010 at 12:00 PM.

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