0 1 By Victor Chan In Excel Macros & VBAPosted February 15, 2019Excel VBA Case Study #2 – Map MouseoverMake an interactive Excel map using VBA to detect [...] READ MORE
0 3 By Victor Chan In Excel Macros & VBAPosted February 8, 2019VBA Case Study – #1 Sheet Saver and Sender Macro (18 steps in 10 seconds)Summary: Why invest time learning VBA if it doesn’t [...] READ MORE
0 2 By Victor Chan In Excel Macros & VBAPosted February 1, 2019Excel VBA Tutorial – #10 Using built-in Excel functionsLearn how to use built-in Excel functions in your own Excel [...] READ MORE
0 4 By Victor Chan In Excel Macros & VBAPosted January 25, 2019Excel VBA Tutorial – #9 Writing Macros with VariablesLearn how to use Variables when programming Excel VBA [...] READ MORE
0 5 By Victor Chan In Excel Macros & VBAPosted January 18, 2019Excel VBA Tutorial – #8 Introduction to Variables and ConstantsSummary: Are you ready to take your Excel VBA [...] READ MORE
0 9 By Victor Chan In Excel Macros & VBAPosted December 10, 2018Excel VBA Tutorial – #7 Properties of ObjectsSummary: In the previous tutorial (#6 Collections) [...] READ MORE
0 10 By Victor Chan In Excel Macros & VBAPosted November 26, 2018Excel VBA Tutorial – #6 Collections of Workbooks, Sheets and CellsSummary: If you followed our Excel VBA tutorials 1 – 5, [...] READ MORE
0 10 By Victor Chan In Excel Macros & VBAPosted November 19, 2018Excel VBA Tutorial – #5 Most commonly used Excel VBA commandsSummary: In the first four tutorials of this series we learned the [...] READ MORE
0 4 By Victor Chan In Excel Macros & VBAPosted November 12, 2018Excel VBA Tutorial – #4 Editing recorded macro codeSummary: How do you make a macro recording more user friendly? Let’s [...] READ MORE
0 4 By Victor Chan In Excel Macros & VBAPosted November 5, 2018Excel VBA Tutorial – #3 Running Recorded Macros Step-by-stepSummary: Don’t you just hate it when you run a recorded macro and it [...] READ MORE