+ Reply to Thread
Results 1 to 6 of 6

ComboBox.Clear - Unspecified error

  1. #1
    Registered User
    Join Date
    04-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    19

    ComboBox.Clear - Unspecified error

    Hi,

    I am using two ActiveX Control Comboboxes in my worksheet. When the worksheet activates, I want to clear both comboboxes and update their list content. The first combobox seems to work fine however when I inserted the second one I get a Runtime Error '-2147467259 (80004005)' Unspecified Error' when I try to clear the second combobox (Combobox2.Clear). Its quite strange.

    I attach my code:

    Please Login or Register  to view this content.
    Any ideas?

    Thanks a lot in advance

  2. #2
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    17,942

    Re: ComboBox.Clear - Unspecified error

    I am guessing this error happened beginning the second time this code ran. You can't Clear a combobox that is using ListFillRange. The simplest solution is to remove the Clear statement.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Registered User
    Join Date
    04-11-2013
    Location
    Germany
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: ComboBox.Clear - Unspecified error

    Yes! You are right! It happens at the second time it runs.

    I use the Clear statement to remove the visible value of the combobox, since when I change the ListFillRange the last selected value of the combobox remains visible although it doesnt belong to the new ListFillRange.

    Is there any statement to clear the "visible" value of the combobox?

    Thanks a lot!

  4. #4
    Forum Moderator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    365
    Posts
    17,942

    Re: ComboBox.Clear - Unspecified error

    Use this where you had your Clear statement:

    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    10-18-2015
    Location
    Bogota
    MS-Off Ver
    2010
    Posts
    1

    Re: ComboBox.Clear - Unspecified error

    Thanks a lot!!!

  6. #6
    Registered User
    Join Date
    04-11-2021
    Location
    Budapest, Hungary
    MS-Off Ver
    2020
    Posts
    1

    Re: ComboBox.Clear - Unspecified error

    I thanks a lot too!!!

+ 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. Controls with Unspecified Error Message
    By adam2308 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-22-2012, 06:16 AM
  2. Unspecified Error
    By davegugg in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-24-2010, 05:12 PM
  3. Unspecified Automation Error
    By _Yoyo in forum Excel General
    Replies: 1
    Last Post: 05-23-2005, 04:06 PM
  4. [SOLVED] Unspecified Automation Error
    By _Yoyo in forum Excel General
    Replies: 0
    Last Post: 05-20-2005, 06:06 PM
  5. Unspecified Automation Error
    By _Yoyo in forum Excel General
    Replies: 0
    Last Post: 05-20-2005, 12:06 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