100 Excel VBA examples

Take a Preview

What our customers say

Brian - Tennessee, United States
"After going through these pages today, I want to say "Thank you!!" for your website. It truly is the best VBA website I have visited. I have been trying to learn VBA by going to several of the Excel forums on the internet, but I only pick up bits and pieces here and there. Thank you again, Niels!"

James - Vancouver, British Columbia, Canada
"I liked that they were easy to follow along and I began to actually understand what I was doing rather than just copying everything into my worksheet."

Lucio - San Juan, United States
"You are the best!! This website is outstanding for saying the least. It really saved me a lot of time while giving me the opportunity to learn by practicing. And the Customer Service is excellent as well. I had my questions answered in less than 24 hours. I recommend it to everyone who likes to improve their skills in VBA. Thanks for having such an amazing site like this one."

Faheem - Lahore, Pakistan
"This is an excellent site about Excel-VBA. I congratulate all involved in this project for useful information and the simplest design."

Motolani - London, United Kingdom
"excel-vba-easy gives you the step by step explanation of how the code works and the actual macro for users to download."

Navneet - Sydney, Australia
"The website and the codes provided makes understanding VBA easy. The customer service is perfect. I had a problem trying to write up a code for something which I thought was complex, and the staff not just provided me with a solution, but the steps provided also included comments and it really made life easy for me. The staff are quick as well, I had a response within the same day! This website is awesome and the people running it are brilliant."

Sean - Evanston, Illinois, United States
"I can't believe it! I found an explanation I had spent hours searching for. This site is well worth the money!"

David - Los Angeles, United States
"Your Excel VBA online tutorial is great. It is so understandably written, so clearly written, so concisely written, so relevant to the topic. It is clear you really know the topic, and took A LOT of time to put this together."

Seng - Christchurch, New Zealand
"I really love your website. I chose excel-vba-easy over other websites and books because of its easy to follow explanations, logical progression, and examples. I love the examples because that's where most of my learning happens and most of them are relevant to my work."

Susan - Chicago, Illinois, United States
"Thank you so much for the awesome Excel VBA course you've put together! There are others on the net, but I've found yours to be by far the most comprehensive. It's not "dumbed down", yet it's easy to follow step by step."

Jamil - Copenhagen, Denmark
"When you decide to start learning excel VBA, you probably search for a good tutorial or book to learn. Therefore, if you read this feedback, I would say the best practical tutorial to start with would be this website. It is brief, comprehensive and with examples. Good luck."

Mark - Redhill, Surrey, United Kingdom
"I like the look of your site as a beginner to excel and excel vba."

Michael - Folsom, United States
"The examples that are given provide wonderful, well organized code examples that are true learning tools. The fact that this site works with Excel 2010, 2007, or 2003 is a huge plus. Overall, the site is extremely informative and has a very "friendly" tone to it that is inviting."

Stefan - Rotterdam, The Netherlands
"Great examples! It helped me a lot. I'm doing a project at the moment and I keep coming back to your examples. Thanks so much!"

Jared - Atlanta, United States
"This site has captured the fundamentals of Excel's vba and presented it in a clear and concise manner. I have gained both knowledge and understanding to immediately use vba in my workflows."

Andrew - London, United Kingdom
"The way the site is structured is ideal for my needs as I can gradually find out the information I need in a logical step-by-step way, and the various cross-references are also well-structured. I particularly like the accompanying screenshots on the various sections on the site as they add useful context to the textual info/instructions being given and as a complete beginner to Excel VBA and the Visual Basic Editor that is invaluable at times."

Aman - Bangalore, Karnataka, India
"I have gone through your site and it is very good."

Ying - San Gabriel, United States
"Love the website and the programs. Pave way for a better and deeper understanding on Excel VBA. Excellent and would definitely recommend for beginners and intermediates who utilize Excel frequently"

Rodney - Indianapolis, United States
"I had a specific question about VBA and the administrators replied to my question within 24 hours. They showed me a very practical, easy solution to my problem. The solution worked and I learned a lot."

Deniz - Allston, United States
"I stumbled on Excel VBA Easy through a Google search. Am I glad I did! I've been trying to learn Visual Basic for a project I have been working on, and needed to get help ASAP. Many websites promise help and support, but the folks at Visual Basic Easy really gave me the individual attention I needed to move my project along. The response time to my questions was less than 24 hours, which was great. And did I mention the many examples of codes they already have on the website? If you are a Visual Basic beginner, and need to get help fast, you've come to the right place."

Harold D'cruz - London, United Kingdom
"I find it, the code+vba, very useful. Excellent site to read."

Low Seng Kuang - Malaysia
"I like your presentation; it is simple, illustrative and easy to understand. Thank you for helping me to learn this new subject."

Natalia - Sydney, Australia
"I think you guys are doing a great job! There are very few web-sites that are so intuitive and easy to follow! It really does help. I did not have any VBA experience before I joined your site users, but now I feel more or less comfortable and I am able to work with macros."

Roland - Kaposvár, Hungary
"This page is just fantastic with easy and understandable examples. I found lots of macros very useful."

Toby - Ogden, United States
"I enjoyed using the site. It is difficult to find clear, concise advice and help on VBA, but your website, excel-vba-easy, has done a great job of it. I also enjoy the ability to download files and review the code on my own. Thanks guys!"

Mike - Harrow, United Kingdom
"Spot on! That was exactly what I was wanting the 'concept' to do. Very impressed with quick response and also the information provided, truly a great service for 'us beginners'. I know there is a wealth of VBA information out there and to be honest, it becomes mind-bending trying to get what you want out of it together! Having a little help along the way goes much further in enabling oneself to improve, a case of 'lead by example' shall we say."

Rick - Houston, United States
"As a professional geoscientist, but a vb novice, I would like to take this opportunity to thank Niels and the staff at excel-vba-easy for their great web site and for their help with some vb code I needed to get started with some modeling in Excel. I would strongly recommend excel-vba-easy.com to my friends and colleagues."

Khodijah - Iowa, United States
"Thank you so much for your help. I have been working with the project for a week now, and you solve it just like that! Excel VBA easy is the best!"

Almar - Eelde, The Netherlands
"Great website on VBA. I learned a lot in a very short time. Programs are good and instructions helpful. Thanx!!"

Richard - San Ramon, United States
"I have wanted to upgrade my excel skill for years but I always avoided VBA because it seemed too much like hard-core programming and I am not a programmer. I looked at a lot of other online tutorials before running across Excel-VBA-Easy, but none offered practical help or easy, straight forward instruction. Excel-VBA-Easy.com made learning VBA genuinely easy and I was able to put what I learned to immediate use. The lessons are practical and easy to understand yet comprehensive. The library of examples provide useful practice and lots of ready-to-go solutions. Great job guys!"

Peter - Belfast, United Kingdom
"I like the clear layout of the site so that it is easy to find exactly what I am looking for and the ease of downloading the examples."

Jesse - Newport Beach, California, United States
"You have the simplest, most comprehensible material i've found for a VBA beginner. Your website is very helpful!"