Looks like the problem has not been solved. It worked on my previous post one time but now that I have run it a couple of more times, the problem continues. I have posted a new copy of the workbook that incorporates the suggestions made earlier. And I have moved the prompt to control-break to the the code that sets the listbox from data saved on a worksheet. The problem is clearly that I am unable to set all 3 listboxes per data on a worksheet robustly. 2 of the 3 listboxes seem to set, and not always the same 2 but one is always not setting. I think if this is fixed then I can set variables later in the code.
|