+ Reply to Thread
Results 1 to 4 of 4

Userform NO empty controls

  1. #1
    Registered User
    Join Date
    06-01-2013
    Location
    GVA
    MS-Off Ver
    Excel 2010
    Posts
    10

    Userform NO empty controls

    Hi all,

    I have a quite simple UserForm that contains 4 TextBox 1 ComboBox and 1 MonthView calendar, and a CommandButton, used to proceed to the next step.
    Pretty straight forward, I would like to have a loop /code that checks if all the mentioned controls above have a non null input when clicking on the command button.

    I have stumbled over the internet with various solutions but didn't manage to get them to work properly with my case.

    This is the code that I currently have, it does check the TextBox, but not the ComboBox nor the MonthView Calendar input.
    FYI: all the TextBox have given names and are not named as mentioned below.

    Please Login or Register  to view this content.
    Also to mention, the ComboBox is populated at the initialization of the UserForm with the following code (I am not sure if this is necessary but here it is )


    Please Login or Register  to view this content.
    Thank you very much for your help.

    FP

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform NO empty controls

    Please Login or Register  to view this content.
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform NO empty controls

    I am unable to edit the post above.

    Please treat it as a tutorial.

    The command button Click event demonstrates how to test the controls.

    Please Login or Register  to view this content.
    Is a better way to load the Listbox

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform NO empty controls

    I am unable to edit the post above.

    Please treat it as a tutorial.

    The command button Click event demonstrates how to test the controls.

    Please Login or Register  to view this content.
    Is a better way to load the Listbox

+ 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] Userform Controls shortcut - close userform by escape key
    By ag273n in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-05-2014, 06:23 PM
  2. [SOLVED] Userform Controls (Allowing empty strings when match required = True)
    By stuart010 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-15-2012, 06:27 AM
  3. Which controls would be best to use for this Userform?
    By Kr4ftw3rk in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-24-2008, 09:50 AM
  4. UserForm Controls
    By newbie13 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-20-2008, 05:37 AM
  5. [SOLVED] userform controls
    By natanz in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 11-02-2005, 06:20 PM

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