[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 718
  • 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
Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

 
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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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