+ Reply to Thread
Results 1 to 7 of 7

Stopping Next i and adding Message Box

  1. #1
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Stopping Next i and adding Message Box

    Hi there!! Still pretty new to VBA code but learning a lot! I have a seemingly easy task that I am having difficulty figuring out. What I would like to make happen is to create folders based on cell values, but if there is a row without anything I would like the action to stop and then a message box pop to say the task is complete. The code I have below creates the folders but continues even when the specified cell is empty. Hope that makes sense.

    Any and all help is greatly appreciated!!

    Please Login or Register  to view this content.

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Stopping Next i and adding Message Box

    Maybe:

    Please Login or Register  to view this content.
    Last edited by xladept; 11-26-2014 at 12:00 AM. Reason: Had Exit Sub After the end if -see xlbiznes code below:(
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Re: Stopping Next i and adding Message Box

    Thanks so much for replying! I tried this code but it now only creates the dated folder but not the other folders within or have the message box pop up. Any suggestions? I've been playing with it but haven't had any ideas.

    Thank you!!

  4. #4
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Stopping Next i and adding Message Box

    I'll look at it again tomorrow>

  5. #5
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Stopping Next i and adding Message Box

    try this

    Please Login or Register  to view this content.
    Happy Computing ,

    Xlbiznes.

    To show your appreciation please click *

  6. #6
    Registered User
    Join Date
    09-22-2014
    Location
    Los Angeles, CA
    MS-Off Ver
    2011
    Posts
    39

    Re: Stopping Next i and adding Message Box

    That worked perfectly!!! Thank you!!!

  7. #7
    Valued Forum Contributor xlbiznes's Avatar
    Join Date
    02-22-2013
    Location
    Bahrain
    MS-Off Ver
    Excel 2007
    Posts
    1,223

    Re: Stopping Next i and adding Message Box

    you are welcome, glad i could help.

+ 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. Stopping Prompt Message After One Time
    By JonathonHardy in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-16-2011, 11:18 AM
  2. Stopping a message alert
    By dalewms2 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-31-2011, 02:44 PM
  3. Stopping Disable/Enable Macro Message
    By Jenno in forum Excel General
    Replies: 2
    Last Post: 02-13-2007, 09:54 AM
  4. Stopping the Macro Warning Message
    By Jurrasicway in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-19-2006, 10:10 AM
  5. [SOLVED] message without stopping execution?
    By Stefi in forum Excel Programming / VBA / Macros
    Replies: 19
    Last Post: 07-14-2005, 07:08 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