exit event on msforms.listbox

richadj4 · Aug 12th 2013

Having a little difficulty here. I have several somwhat complex userforms, some of which generate their own controls on the fly. This has not yet been a problem for me, but when generating a listbox through vba, it does not appear to have several of the events (exit being the one I need at the moment) Is there some difference between a listbox created using the "toolbox" and one created by msforms.listbox?

**pike** · Aug 12th 2013

Re: exit event on msforms.listbox

Hi
can you use

Code

ListBox1_LostFocus()

as a exit event

Kyle123 · Aug 13th 2013

Re: exit event on msforms.listbox

You can't do it; the Exity and entery events, I believe are really raised by the parent container which is why you don't see them, there are some laborious work arounds, but not really worth it in my opinion; have a look here: http://www.mrexcel.com/forum/e…cus-userform-control.html

exit event on msforms.listbox

Participate now!

Share