ActiveX Listbox - Items disappear after click while code is running (then reappear when complete)

[bs0d]

I have an ActiveX listbox on my sheet. I have a number of sub routines that run once the user clicks an item in the list. My issue is that once a user clicks an item in the list, the listbox appears empty briefly while the code is running, and the items show back up when the code is done. This takes about a full second. In a perfect world, the listbox does nothing while the code is fetching data. Does anyone have experience resolving this behavior?

 

[Fluff]

I've never connected a listbox to another app, so don't know how it works.
I was just thinking that if you are querying the DB again during the Click event, it might be causing the listbox to loose it's data temporarily, hence I suggested writing the data to a sheet to see if you still get the same problem.

 

[bs0d]

I've never connected a listbox to another app, so don't know how it works.
I was just thinking that if you are querying the DB again during the Click event, it might be causing the listbox to loose it's data temporarily, hence I suggested writing the data to a sheet to see if you still get the same problem.

Ok, it's worth testing. I'll give it a shot.



Thanks,

 

[bs0d]

I have resolved this issue by converting to a MS Form listbox. My only complaint is that the list items appear to be particularly small. I have not identified any way to alter the font size of the ms form listbox.