Results 1 to 9 of 9

Automation error on Combo box

Threaded View

ronettes Automation error on Combo box 10-21-2022, 09:40 AM
Marc L Re: Automation error on Combo... 10-21-2022, 10:03 AM
Marc L Re: Automation error on Combo... 10-21-2022, 10:40 AM
ronettes Re: Automation error on Combo... 10-24-2022, 03:54 AM
Marc L Re: Automation error on Combo... 10-24-2022, 06:05 AM
JEC. Re: Automation error on Combo... 10-24-2022, 04:36 AM
Sintek Re: Automation error on Combo... 10-24-2022, 06:11 AM
Marc L Re: Automation error on Combo... 10-24-2022, 06:26 AM
Sintek Re: Automation error on Combo... 10-24-2022, 06:28 AM
  1. #1
    Registered User
    Join Date
    03-30-2014
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    63

    Automation error on Combo box

    HI There Gurus

    Need some help, As I am having "writers Block" on an error I am getting.

    I have Combo Boxes on my "TEMPLATE" Worksheet which displays a list from the "Product"(Combobox2) or "Packaging" (Combobox3) Tabs. YOu have to select the cell where the info is to be stored. Then have the option to search, or partially search for the product, then be able to select it. The value will then be stored and the combo box will reset to empty.

    I always worked, but not sure if it is an Office365 error or me.

    I get the following Error:

    Run-time error '-2146232576 (80131700)':
    Automation error

    Then the debugger takes met to this section
    Set dar = CreateObject("System.Collections.ArrayList")
    Thanks very much
    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. REPOSTING THREAD: Run time error 2146232576 (80131700) - Automation Error
    By bala04msw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-14-2018, 07:39 AM
  2. Loop Nesting is returning Run-Time Error '-2147221080 (800401a8)': Automation Error
    By ChristopherBrandonKi in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2014, 02:36 PM
  3. [SOLVED] Run-tim error -2147467259(80004005): Automation error Unspecidied error
    By mattress58 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2014, 12:12 PM
  4. [SOLVED] Error: automation error the object invoked has disconnected from its clients
    By siroos12 in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 12-24-2013, 08:56 AM
  5. Facing 'run-time error -2147217871 (80040e31) Automation error' in excel VBA
    By junaidanjum in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-25-2013, 03:48 AM
  6. Replies: 7
    Last Post: 05-15-2013, 09:02 AM
  7. Replies: 7
    Last Post: 01-15-2010, 02:34 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