+ Reply to Thread
Results 1 to 4 of 4

Error 13 on one machine

  1. #1
    Registered User
    Join Date
    08-30-2022
    Location
    eindhoven, netherlands
    MS-Off Ver
    365
    Posts
    2

    Question Error 13 on one machine

    I'm currently testing some code for document automation on multi-user environment. For one specific machine there is a error 13 mismatch, where on other the code runs perfectly.

    All machines have been installed with the same office version (365); all machines have been updated to the latest version.

    Please Login or Register  to view this content.
    When I run the code step by step the following happens:
    First iteration:
    lstbx.name = "listType"
    IsItemInListbox gets called and is set to true
    Second iteration
    lstbx.name = "listComponent"
    IsItemInListbox gets called and is set to true and I get a type 13 mismatch error when the code steps out of the IsItemInListbox.

    I can bodge it by using an "On Error Resume Next", however I'm not sure that's the best way to go about it. It's one specific machine that outputs this error, the other machines don't have this. Does anyone know what could be the problem?

  2. #2
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,521

    Re: Error 13 on one machine

    Please Login or Register  to view this content.
    Why, when the IsItemInListbox function returns a logical value?

    Artik

  3. #3
    Forum Expert
    Join Date
    10-06-2017
    Location
    drevni ruchadlo
    MS-Off Ver
    old
    Posts
    2,246

    Re: Error 13 on one machine

    Quote Originally Posted by Roelofs View Post
    ... I get a type 13 mismatch error when the code steps out of the IsItemInListbox ...
    1. What does the 'FillListBox' function call look like ?
    2. What does the "arr" variable look like: what is in it and what is the data source for this variable ?

    An example would come in handy.
    Last edited by mjr veverka; 08-30-2022 at 06:52 AM.

  4. #4
    Registered User
    Join Date
    08-30-2022
    Location
    eindhoven, netherlands
    MS-Off Ver
    365
    Posts
    2

    Re: Error 13 on one machine

    Thank you! I completely glanced over the UCase. My issue is solved.

+ 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. excel macro running on machine, but not on other machine. Language setting?
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-02-2017, 09:09 AM
  2. [SOLVED] run time error on other machine
    By adamheon in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-24-2016, 04:31 PM
  3. excel userforms created with a 32 bit machine not loading on a 64 bit machine
    By stewe in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2016, 10:12 PM
  4. Working code on my machine is returning out of range error on another machine.
    By je.suis.ketan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-16-2012, 11:51 PM
  5. error 40351 on one machine but not other
    By DKY in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-06-2008, 01:31 PM
  6. [SOLVED] Reference & update destin. cells on 1st machine from source workbook on 2nd machine
    By eastside877@yahoo.com in forum Excel General
    Replies: 2
    Last Post: 03-01-2006, 12:25 AM
  7. [SOLVED] Reference & update destin. cells on 1st machine from source workbook on 2nd machine.
    By eastside877@yahoo.com in forum Excel General
    Replies: 6
    Last Post: 02-28-2006, 01:20 AM

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