What is Excel?  There's a tricky question!  Well, an Excel file, at the highest level of granularity, consists of cells.  Our ability to manipulate those cells - and the relationships between them - is a key determinant of our Excel (VBA) capability.  So, in part 2 of the Excel VBA Beginner Fundamentals series, let's learn how to work with cells using Excel VBA. 

📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES

CLICK HERE TO WATCH THE VIDEO 

 

First, we learn how to 'read' a cell in the spreadsheet from the VBA Editor.  With our old friend the message box (aka 'msgbox'), we show how VBA can recognise the value in a cell with a really simple line of code.  Next, we work the other way by 'writing' a value to the spreadsheet from the VBA Editor - yes, it's a two-way street!  Finally, we explore how to write a value from one cell to another using instructions in the VBA Editor.  Make sure you do your own experimentation to consolidate these key ideas ... 

Excel VBA Beginner Building Blocks 4, 5 and 6 are in the books!  Make sure you download the course handbook (available in PDF and Excel format) to monitor your progress. 

Download the course handbook to access the learning template for this session. 

📊DOWNLOAD COURSE HANDBOOK / EXCEL FILES