+ Reply to Thread
Results 1 to 3 of 3

Endless loop with two activex listbox'

  1. #1
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Endless loop with two activex listbox'

    Hi all,

    I've got a sheet with two listbox'. Depending on what was chosen in the first one, the second one changes its value:

    Please Login or Register  to view this content.
    Both of them execute another code:

    Please Login or Register  to view this content.
    The code itself is working perfectly. If I change the "Combobox2_Change" event to "Combobox2_LostFocus" and leave everything else unchanged, everything works. But when it's set to "Change" there is always an error.

    Anyone can make out something of this? I'll try to desensibilize the workbook in a few mins.
    If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.

  2. #2
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Endless loop with two activex listbox'

    Test.xlsm

    file attached

  3. #3
    Valued Forum Contributor
    Join Date
    03-17-2012
    Location
    Warsaw, Poland
    MS-Off Ver
    2007/2010
    Posts
    555

    Re: Endless loop with two activex listbox'

    anyone got an idea?

+ 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. [SOLVED] For next loop multiselect activex listbox won't list items in seperate cells. Only 1st
    By Dabbler39 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-05-2013, 03:25 PM
  2. Endless loop
    By kathhying in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-28-2011, 01:17 PM
  3. Endless Loop?
    By teaker in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-16-2009, 10:39 AM
  4. Endless loop
    By freddie mac in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-01-2006, 10:25 AM
  5. [SOLVED] Endless loop?
    By John in forum Excel Programming / VBA / Macros
    Replies: 23
    Last Post: 08-02-2005, 02:05 PM

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