+ Reply to Thread
Results 1 to 3 of 3

Please help quick, check multiple textboxes.

  1. #1
    Registered User
    Join Date
    05-17-2013
    Location
    Wormer, the Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    2

    Exclamation Please help quick, check multiple textboxes.

    Hi,

    This is my code:
    Please Login or Register  to view this content.
    I don't understand why it doesn't work.

    It has to check if txtStraatnaam AND txtHuisnummer are not empty, if they are not empty, it has to make a capital of the first letter of txtStraatnaam.Text. Then the rest of txtStraatnaam has to come up on the label, then a space, and then txtHuisnummer

    Edit: It tells me that the first part is wrong

    Please help me

    Robomanrob
    Last edited by Robomanrob; 05-17-2013 at 01:54 PM.

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: Please help quick, check multiple textboxes.

    If Not (Me.txtStraatnaam.Text And Me.txtHuisnummer.Text) Like ""

    try splitting it up....

    If NOT (Me.txtStraatnaam.Text Like "" AND Me.txtHuisnummer.Text Like "") THEN
    ....
    END IF
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    05-17-2013
    Location
    Wormer, the Netherlands
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Please help quick, check multiple textboxes.

    looks like it worked, thanks a lot!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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