+ 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 Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,752

    Re: Help in (If Statement) VBA

    Have you pasted all your code?
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  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 Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,752

    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