+ Reply to Thread
Results 1 to 4 of 4

Help in (If Statement) VBA

  1. #1
    Registered User
    Join Date
    04-04-2020
    Location
    USA, TN
    MS-Off Ver
    2019
    Posts
    2

    Help in (If Statement) VBA

    Greetings,

    Basically, I'm trying to run this code into userform & it should be displayed on listbox after pressing Add btn

    but I want to make if statement if END TIME is blank then it should procced because now it giving Error msg (Type Mismatch)

    furthermore, if end time less than START TIME then it shows Error msg


    Thanks!



    Please Login or Register  to view this content.
    Last edited by hhalyami43; 04-04-2020 at 10:18 AM.

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

    Re: Help in (If Statement) VBA

    Have you pasted all your code?
    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
    Registered User
    Join Date
    04-04-2020
    Location
    USA, TN
    MS-Off Ver
    2019
    Posts
    2

    Re: Help in (If Statement) VBA

    Quote Originally Posted by mehmetcik View Post
    Have you pasted all your code?
    Please Login or Register  to view this content.

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

    Re: Help in (If Statement) VBA

    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] IF statement with IF Statement as logical test, and output if false
    By wetbean in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-19-2018, 12:59 PM
  2. Replies: 2
    Last Post: 07-09-2015, 04:25 PM
  3. compile error expected line number statement end statement
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-18-2014, 10:12 AM
  4. VBA Compile Error : line number or label or statement or end of statement
    By excellearner121 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-04-2013, 06:41 PM
  5. Replies: 4
    Last Post: 06-01-2012, 10:05 AM
  6. Replies: 4
    Last Post: 05-16-2012, 05:33 PM
  7. [SOLVED] Utilize a Select Case Statement in Target Intersect Statement
    By max57 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-29-2009, 08:55 PM

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