Results 1 to 5 of 5

Getting Type Mismatch with String passed to a Function with String parameter

Threaded View

  1. #1
    Registered User
    Join Date
    03-18-2014
    Location
    Manila, Philippines
    MS-Off Ver
    Excel 2007
    Posts
    9

    Getting Type Mismatch with String passed to a Function with String parameter

    Hello,

    Please view this XLSM file. In the DMG_SLIP Sheet, there is a Find button that will run the command findSlip(), now I created a function called getSearchArrayMultCriteria(strSearch As String). When I use this function and pass a string to it, it says type mismatch. I don't know why but I already created the variable statusString and set it to String but still when I use the function, it will say type mismatch.

    Now, I just renamed this function from the original getSearchArray(strSearch) that also accepts a string parameter, I am not having any problems with this one. The only difference with the original function is that I pass a numeric value to it but no problems there.

    Can anyone help?

    Thanks a lot!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA: Array of User Defined Type passed as parameter to function
    By Bezzie in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-14-2013, 07:08 AM
  2. ODBC SQL string - type mismatch
    By spike1988 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-25-2013, 06:41 PM
  3. Error passing element of string array get ByRef argument type mismatch
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-17-2011, 02:59 PM
  4. Testing value of string but its a number........gives type mismatch error
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-18-2011, 05:06 PM
  5. Type mismatch. How do combine a string and a number to make a range?
    By 111StepsAhead in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-21-2011, 11:17 AM

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