The program in the attached file is used by Account Managers to report chemical readings observed at a customer's location. Some Account Managers may have 10 or more customer files to maintain. I have developed a code module to support future releases of the program that systematically copies customer data from existing files into the newer version of the program.
In an effort to reduce screen flashes I created a Modeless Userform that informs the user of progress throughout the program update progress. The issue I am having is that the Userform opens and displays correct information initially. After a file is updated, the Userform is Unloaded and then the Show command is issued as the next file is being manipulated. Although the Userform remains visible on the screen, it is now simply a white blank form with no progress information shown.
I am attaching 3 files than can be used by anyone who would like to correct this problem.
File 1 which is the new program file is "WaterTech Report Tool Vers 5. The code module in question is "NewProgram_Import_All_Fil
Files 2 & 3: "Bar S Foods-2" and "Bar S Foods-2-1" are 2 files that would be updated via this code module. Copy these 2 files to a Folder on your PC. The program steps you through selecting these files.
For any seasoned programmer that attempts to help me I ask that you forgive my "Novice" mistakes. This was a first effort at programming in VBA. While my approach may leave you snickering at my less than desirable approaches I can assure you that other than this issue with the Userform the program delivers the desired outcome. Through monitoring Experts Exchange and other VBA forums I have learned greatly about more professional approaches and have begun the process of updating my code to apply those practices such as not Selecting or Activating and using "Cells" to reference Ranges rather than needing to convert the numeric value of Columns to an alphanumeric value.
Thanks in advance for any assistance that can be provided.