Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combobox Change event (2k)

    I am experiencing something strange: a combo box_change event is being triggered as if it were a worksheet_Change event,
    ie it fires whenever any cell on the sheet is edited or the contents deleted.
    There is no worksheet_change event on the subject sheet.
    ThisWorkbook module is empty.

    AFAIK there are two situations that would triggger the cbo_change event:
    1. directly- making a selection in the box
    2. indirectly - changing the LinkCell

    I suspect maybe the latter is somehow involved but I can't figure how.

    Any ideas on troubleshooting this?
    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Combobox Change event (2k)

    Could you post a demo sheet exhibiting this behaviour?

    Or at least describe the setup and any other code involved.

    Steve

  3. #3
    3 Star Lounger
    Join Date
    Feb 2003
    Posts
    363
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combobox Change event (2k)

    Steve,

    Thanks for the reply. In an effort to get something small enough to send, I made a copy of the sheet in a new wbk.
    The problem does not happen in the new bk. I'll keep looking and get back as needed.

    Thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •