+ Reply to Thread
Results 1 to 3 of 3

exit sub and clear combox inputbox strange ?

  1. #1
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    exit sub and clear combox inputbox strange ?

    on the sheet there is e combox with program code on it.
    I check it the use hase select a cell only in weekdays an not outsite the calendar.
    That works ok. The user get a message.
    But why he do first the exit sub by elseif and do not stop and goes to the exit above the elseif
    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,721

    Re: exit sub and clear combox inputbox strange ?

    I am sorry but I do not understand this question:

    But why he do first the exit sub by elseif and do not stop and goes to the exit above the elseif

    Here is the flow of your code:
    Please Login or Register  to view this content.
    What do you want to happen?
    Last edited by 6StringJazzer; 02-22-2018 at 02:36 PM.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    12-25-2012
    Location
    gent,belgium
    MS-Off Ver
    Excel 2021
    Posts
    146

    Re: exit sub and clear combox inputbox strange ?

    what i want

    Is that the user get a message when he make a selection that containts an day of the weekend and aslo when i select a cell outside te calender.
    Lik i do it now when the user make a correction the the code wil not run any more because the code is on the change event off the combox.
    and also prevent that the user can put 2 code of the combox on the same day

+ 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 on InputBox Cancel
    By qwerty7 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-01-2015, 07:33 PM
  5. Strange problem with InputBox
    By Diesel_Industry in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-16-2011, 05:25 AM
  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

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