Problem with Listbox using VB6 in Excel 2007

[hectorfm85]

Dear colleagues, I have decided to write to you because I have been trying all morning and can not find an explanation.

I created a VB6 form through Excel 2007, with connection to an Oracle DB. Depending on how you start filling out the form works better or worse. I mean, if you first start selecting items from listboxes and after filling the content of other textboxes,it never gives problems. but if I do the opposite, ie, filling first the textboxes and then going to certain listboxes to select some of its elements, the form does not allow me to select any as if they were disabled. The issue is that it seems somewhat random, and that only happens sometimes, and if I change my Excel sheet and return to the original, most times the Listbox elements can be finally selected (there's no code implied in switching pages).

I do not think that is a code problem, because in no timeI manipulate the Enabled property of the ListBox, I do not know whether this will be a performance issue (there are many form elements) and if it has some simple solution. Any idea that may be of help will be greatly appreciated.

Regards,



Hector

[si_the_geek]

Welcome to VBForums

Thread moved to the 'Office Development/VBA' forum... note that while it certainly isn't made clear, the "VB Editor" in Office programs is actually VBA rather than VB, so the 'VB6' forum is not really apt

[RobDog888]

Welcome to teh Forums.

Have you tried to create a test local db and have a copy of the data in it. Connect to it and see how that goes? Or you could, depending upon the db and data, place the data in a text file locally.

If it behaves the same then perhaps some trace file writting is needed or at least try breakpoints