Code Shortening

Hello, I've read your project requirements thoroughly. It's quite an easy task and I can achieve this due to my experience with VBA script. It will be quick and accurate. I will start immediately and complete it within a few hours. If interested, we can discuss this further on chat.

Hey, 1) You wrote - > I have attached a piece of code that I would like to be shorter for processing speed Then mentioned switching to a FOR loop - > "For iIndexA = 0 to 39" You have 40 things to do. Writing each of the 40 tasks separately, or putting them in a loop, is *the same work*. The code will do these 40 things, one after another, either way. Rewriting code this way will *not* make anything faster, regardless of loop type. 2) The code gets values from a range of cells, then shows them in a form, 40 times. This is trivial and will execute in, say, 1 second. A 50% improvement would go from 1 second to half. Who would notice? Unless there's something else going on, or a problem, improving performance for this particular task seems like flogging a dead horse. An obvious thing would be to read data once and iterate that instead but the improvement might be marginal. 3) You mention - > and reduced size on disk Your existing logic is 6 lines. * 40 is 240 lines total, so roughly 20kb. Rewriting code as a loop will save you roughly 19.5k. Tiny. Usually an Excel file is actually internally a zip file, so you would save even less. Remember also that files are physically stored in chunks. These chunks can be larger than 19.5k so there might be no physical space saved at all. A loop would be more readable but not inherently better. Iterating form controls might be smaller. But the stated goals seem unrealistic. Oh yeah, there might be a bug - the code never unticks.

Hello, Sir. Expert of Excel VBA is here. I've gone through your project requirement and found my skill best suited in this one. I am familiar with technologies such as C++, VB, MS Office, Database Programming, Data Processing. I am the best suitable candidate to serve you. If you hire me, I will provide you good result. Let's discuss details about your job in chat. Thanks, Good luck.

Hi I gone through your code. Why can't we try do while instead of for loop. If you can give me your file I can try it out. Please initiate Chat to discuss.

Dear. ........................................ I am ready to start the task. please check my review. If you want to work with me, it is my pleasure. Let's start. ....................... Thanks.

I have had extensive experience with VBA and should be able to optimise the code for you. To get a better understanding of the work that will needed to be done I will need to have a look at the current vba project to determine what controls you are using. Once I have that information I am confident I'll be able to complete the project quickly for you. Please feel free to message me if you would like additional information. Best Regards Josh

Hi, i'm an informatyic engineer with more than 15 years of experience, i think that i can do this worok for you. If you are intersted, please contact me in private. Thank you