Error type 13 Mis Match error

  • hi when i run my login userform and click ok a macro message shud pop up stating the expired accounts on my database it worked fine before but when i tried to run it ERROR TYPE 13 pops up and its higlighting the

    LDiff = .Range("Q" & LRow).Value2 - Date

    part of my code
    LDiff was declared as Long

    did i miss anything? hope u guys can help me thank you in advance

    here the whole code

  • Re: Error type 13 Mis Match error

    i did that but it just gave me the same error i did found out how to solve it

    LDiff = CDate(.Range("Q" & LRow).Value2) - Date

    placed the cDate

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!