+ Reply to Thread
Results 1 to 4 of 4

ComboBox_Change Event Not Triggering

Hybrid View

  1. #1
    Forum Contributor yay_excel's Avatar
    Join Date
    08-12-2011
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    190

    Unhappy ComboBox_Change Event Not Triggering

    Hello, I have a combobox on a userform that seems to trigger the Change event selectively. So far I have been unable to detect why is it not working as expected. Has anyone else experienced something similar?

    PS: It behaves similarly if I adjust the code to the AfterUpdate event. Also, I have tested with a msgbox to pop up with "ComboBox Changed" and the rest of the code disabled and at times the msgbox does not pop up when I change the combobox so it is not a problem with the code; the event is not triggering.

    Thank you!

  2. #2
    Forum Expert jaslake's Avatar
    Join Date
    02-21-2009
    Location
    Atwood Lake in Mid NE Ohio...look it up.
    MS-Off Ver
    Excel 2010 2019
    Posts
    12,749

    Re: ComboBox_Change Event Not Triggering

    Hi yay_excel

    Has anyone else experienced something similar?
    Sure...many times. My experience...use break points. You're best bet is to post your workbook with UserForm and code...let us SEE what's happening (or not). Perhaps we can help.
    John

    If you have issues with Code I've provided, I appreciate your feedback.

    In the event Code provided resolves your issue, please mark your Thread as SOLVED.

    If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.

  3. #3
    Forum Contributor yay_excel's Avatar
    Join Date
    08-12-2011
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    190

    Re: ComboBox_Change Event Not Triggering

    I have attached the workbook in question. The problem lies on the Diameter combobox in the Materials tab. If Diameter is left as a dash, the regular items (Item…) should appear in the list. When a diameter is selected, the diameter items (Dia…) should appear. I have not yet experienced the problem prior to switching to a new multipage tab but it happens frequently when I have entered many items without closing and reopening the form. When the problem does occur, I switch the diameter again to a random selection and then back to the correct one and it works fine. Thank you in advance for any input you may have regarding the change event not triggering or anything else about the form you happen to notice as I am completely self-taught and could use a lot of improvement I'm sure.

    PS: To avoid error messages while testing, enter a random number into the Job Number field preceded by a capital T. Click the “Start Entering” button on the Item List page to bring up the form.

    Thank you!
    Attached Files Attached Files

  4. #4
    Forum Contributor yay_excel's Avatar
    Join Date
    08-12-2011
    Location
    Canada
    MS-Off Ver
    2013
    Posts
    190

    Re: ComboBox_Change Event Not Triggering

    Does anyone have any ideas?

    Thank you very much.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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