Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 720
  • Last Modified:

ActiveX Listbox events do not fire

Hi there,

I've got a form in an Excel VBA program that contains listboxes displaying user selections. When these listboxes are emptied, I want to disable a commandbutton on the form to prevent the user from continuing without having selected an item. Correspondingly, I want to enable this commandbutton as soon as something is written to the listbox again. All adding/deleting of items in the listbox is handled by the code.
I thought this was easy to achieve using events, but neither the listbox_change event nor the listbox_afterupdate event fires when an item is added to or removed from the listbox. Why not? What kind of event should I use?

best regards,
Einar
0
EISTO
Asked:
EISTO
  • 3
  • 2
2 Solutions
 
FernandoFernandesCommented:
what about the exit event, isn't it firing ?
0
 
EISTOSenior EngineerAuthor Commented:

Hi, Fernando

No, the exit event doesn't fire either

/Einar
0
 
FernandoFernandesCommented:
wait...
what's addin stuff to your listbox ? I mean, listbox is populated via code isn't it ? you dpn't need an even for it...
also, only for the sake of checking everything, is the event handler turned on?

Application.EnableEvents = True
0
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
EISTOSenior EngineerAuthor Commented:

Fernando,

I could write code in each and every routinge that manipulates the contents of the listbox, but it would be a whole lot easier to write it once and for all in an event handler.
....as far as I know, the application.enableevents property does not affect ActiveX-events. It is only applicable to events of objects inherent to Excel.

/Einar
0
 
Rory ArchibaldCommented:
There is no event specifically related to adding an item to a listbox, so I would agree that the code adding the item should call whatever you want triggered.
0
 
EISTOSenior EngineerAuthor Commented:
Thanks guys,

VBA seems to be unable to handle this, so let's close the thread.

/Einar
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now