How To Use Excel VBA Code Real Example P12

How can we use Excel VBA code to speed up manual work in Excel? In this series we explore an example Excel VBA project sent in by Eric, a viewer of the channel. We aim to build an Excel VBA application to move data around a file at the 'click-of-a-button', saving hours of frustrating manual work. The application should be flexible and scaleable enough to handle changes in business circumstances - a challenge indeed! Let's get into it...

Download File Link:
https://tinyurl.com/y4d6ds62
----------------------------------------------------------------
How to be a better Excel consultant? People ask me this question all the time! The obvious answer is ‘improve your Excel skills’, but this answer is not, in fact, the best – at least in my view. If you really want to boost the impact of your Excel consultancy, concentrate not on technical stuff but more on the soft skills that wrap around your coding and make it relevant to the real world. One of these soft skills is client communication. Client communication is particularly important at the end of the project to ensure a smooth handover and guarantee that the customer can get value out of the application.

We explore two ways in which you can communicate better with your client in this video. First, how to build client confidence in the code we have implemented in this project? Macros can be powerful but users, particularly inexperienced ones, can find them troublesome; when does the macro finish, for example? Let’s make this crystal (Christal?) clear for the user by flashing up a message to tell them the routine is finished. Let’s also use a dynamic mechanism to tell the user how much data has been processed. There, we have probably multiplied the real-world impact of this macro by communicating effectively and putting client needs front and centre – cool!

What else do we have to think about before handover to the client? It’s sensible to note the assumptions you have made during development and to be transparent about the weaknesses of the file. Customers can be amenable to some limitations if it makes the coding easier; most customers are impressed by the power of the coding and are prepared to make sacrifices elsewhere in return. So, ask yourself the question, do you need maximum flexibility? More and more coding may not create more and more value; it’s more likely to be a case of diminishing returns.

In the video, we look at how to interrogate code, identifying weaknesses and noting assumptions. This is where neat-and-tidy code that is well-annotated really helps (we told you it would!) I recommend actually listing the limitations and assumptions in the file to remind you to discuss them with the client. This should build confidence in the implementation (and in you as a person), and avoid annoying bugs and crashes later on.
This brings us to the end of the VBA real-world example series. I have done my best to communicate the approach that I use in my projects to create value for real people, in the real world! I would love to hear your impressions of the series. Also, let me know in the YouTube channel comments what else you would like to see on this channel.
----------------------------------------------------------
Series Playlist Link:
https://tinyurl.com/y4pmrkxn

🎁YOUR EXCEL CHEATSHEET
🎁1 Page Summary Of What You Need To Know
https://tinyurl.com/yc7jlmbs

  / tigerspreadsheetsolutions  
  / tigspreadsheets  
http://tigerspreadsheetsolutions.co.uk
Also on Insta :-)