I need to understand how VBA it works and what is the best book that help do excel programming step by step.
The best book I know is this:
But there are some free resources on the Web such as:
If you seriously want to learn VBA, explore this YouTube playlist which I think is the best ever tutorial series on Excel VBA.
Well, thanks for your help and I will visit the provided links.
I do appreciate your advise and I think it would be very helpful as a start for me to get the deep knowledge in programming.
The playlist I shared with you is very systematic one which starts from basics and covers all the advanced topic as well. And each video contains in depth information about the topic covered.
There are approx. 102 videos in the playlist and if you watch all of them and practice along with provided sample files, you will be an expert in Excel VBA very soon for sure.