+ Reply to Thread
Results 1 to 2 of 2

What event to detect click on UserForm ListBox?

  1. #1
    Don Wiss
    Guest

    What event to detect click on UserForm ListBox?

    I have a UserForm. It has a ListBox. MultiSelect is enabled. I want to be
    able to detect a selection, so I can then set the focus to one of the
    buttons. A "ListBox_Click()" macro doesn't fire when you click on a
    selection. So what event does capture a click? (Using xl2002.)

    Don <www.donwiss.com> (e-mail link at home page bottom).

  2. #2
    Doug Glancy
    Guest

    Re: What event to detect click on UserForm ListBox?

    Don,

    It looks like the Change event fires whenever a selection is made.

    hth,

    Doug

    "Don Wiss" <donwiss@no_spam.com> wrote in message
    news:[email protected]...
    >I have a UserForm. It has a ListBox. MultiSelect is enabled. I want to be
    > able to detect a selection, so I can then set the focus to one of the
    > buttons. A "ListBox_Click()" macro doesn't fire when you click on a
    > selection. So what event does capture a click? (Using xl2002.)
    >
    > Don <www.donwiss.com> (e-mail link at home page bottom).




+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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