+ Reply to Thread
Results 1 to 2 of 2

Exit Sub if InputBox Sting is Blank

  1. #1
    Registered User
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    91

    Exit Sub if InputBox Sting is Blank

    Hi --

    I feel like this is a simple fix, but I've yet to find the solution

    I have an InputBox, whose result is 'NewCategory' which i've designated as a string (e.g. 'Dim NewCategory as String')

    How do I set it to exit sub if no value is input (i.e. 'NewCategory' is blank)

    (NewCategory should always be text, if that helps)

    Thank you!

  2. #2
    Registered User
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2010
    Posts
    91

    Re: Exit Sub if InputBox Sting is Blank

    nevermind, figured it out

    for posterity:

    Please Login or Register  to view this content.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Exit Sub When Cancel on InputBox
    By Linkonem in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-19-2017, 02:49 PM
  2. inputbox exit is blank
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-19-2017, 04:11 PM
  3. [SOLVED] Vba to exit sub on cancel on inputbox
    By alkiviadi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-09-2016, 12:17 PM
  4. [SOLVED] Exit Sub if Inputbox cancel, X Button or blank value is used (bypass debug)
    By liamtimms1985 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-18-2015, 07:03 AM
  5. [SOLVED] Exit Sub on InputBox Cancel
    By qwerty7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2015, 07:33 PM
  6. Use Inputbox value to exit sub problem
    By HOT97ECLIPSEGSX in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-21-2010, 04:50 PM
  7. Clean Exit from InputBox
    By scantor145 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-16-2006, 08:55 AM

Tags for this Thread

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