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