The key accomplishments in this video are defining the InRange function so we can more easily control which cells, when clicked, trigger the code contained in the SelectionChange event handler. We also create a Cell.Adjacent property that returns a collection of Cells that are orthogonally adjacent to a selected Cell object, which we use to select positions to Move the player's Challenger to. However, these are supporting code and the bulk of the work in this video is done in the Battle Cell Worksheet SelectChange event handler which executes the code within when a new Range/cell is selected on the worksheet.
0:00:00 Introduction
0:01:30 Words of Warning
0:03:10 Review
0:06:10 ModFunction: InRange
0:19:28 Battle Cell Worksheet SelectionChange Event Handler
0:58:30 Cell.Adjacent Property
1:12:12 Resume SelectionChange
1:17:45 Fix Cell.Adjacent Property
3 июн 2023
