Excel/VBA for Creative Problem Solving, Part 2

Module 1 delves into the functionality of arrays and array functions, covering local arrays in VBA, importing/exporting arrays from/to Excel, and utilizing arrays in subroutines and functions. Learners will work on real-world examples and assignments to consolidate their understanding.

Module 2 focuses on working with strings and .txt files. Learners will explore string functions in Excel and VBA, exporting and importing data from .txt files, and working with tab-delimited .txt files. Practical examples and assignments will reinforce learning.

Module 3 emphasizes iterating through worksheets and workbooks, consolidating information from multiple worksheets into a central worksheet, and importing data from multiple workbooks into a central workbook. Learners will engage with practical examples and assignments to enhance their skills.

Module 4 guides learners through creating user forms for advanced user input/output, covering advanced input boxes, event handlers, input validation, and combo boxes. Real-world examples and assignments will enable learners to apply their knowledge effectively.