Stuartg1978
03-07-2008, 09:29 AM
Hello,
I currently have a problem as follows.
I have a userform that you make a selection from a ComboBox and then press a button that perfroms a whole load of processing. Part of this is as follows:-
Stage 1 - opens up an excel spreadsheet and loads the information into an object called dict (there is about 11,000 data items) then closes the data file
stage 2 - Open another excel file and validate the information in it against the information in the object. The validation areas are defined from the selection ade in the combo box.
I can get the above to work but I want the user to be able to make another selection from the combo box to select the areas of validation for the next file and then process the next file without having to redo stage 1 as it is the bit that takes the longest. i.e. be able to stop the loop for the user to make the new selection and then begin processing without losing the information in the object dict.
Can this be done?
Many thanks for your help in advance
Thanks,
Stuart
I currently have a problem as follows.
I have a userform that you make a selection from a ComboBox and then press a button that perfroms a whole load of processing. Part of this is as follows:-
Stage 1 - opens up an excel spreadsheet and loads the information into an object called dict (there is about 11,000 data items) then closes the data file
stage 2 - Open another excel file and validate the information in it against the information in the object. The validation areas are defined from the selection ade in the combo box.
I can get the above to work but I want the user to be able to make another selection from the combo box to select the areas of validation for the next file and then process the next file without having to redo stage 1 as it is the bit that takes the longest. i.e. be able to stop the loop for the user to make the new selection and then begin processing without losing the information in the object dict.
Can this be done?
Many thanks for your help in advance
Thanks,
Stuart