The Excel VBA .Cells technique is incredibly powerful - and slightly confusing! Learn it and use it with this series of four videos.
Link to download file:
tinyurl.com/y2...
Having learned the basic concept in video 1 (link below), we explore a more complex application in video 2. We witness what Chris terms 'Poetry in Motion' - spreadsheet cells and VBA code working together to create dynamic functionality. A profound capability indeed - but how does it work in this context?
We are familiar with the .cells(rows, columns) basic construct. In the first video, we used 'hard-coded' values, inputted in the VBA editor, in the rows / columns components, to select cells. But we can do better than that - nobody wishes to access the VBA editor every time they need to tweak a function! In the second video, we substitute the 'hard-coded' values (which are best avoided in Excel VBA) for cell references.
What does this do? It means that we can control the selected cell *from the spreadsheet*, with no need to open the VBA editor at all! This interplay between the spreadsheet and VBA editor is what Chris terms dynamic functionality; it is a feature of many powerful VBA routines. In the video, Chris sets up the mechanism and does some testing and experimentation to build confidence in its robustness.
Ah, Poetry in Motion ... :-)
EXCEL VBA .CELLS SERIES RELEASE DATES
Video 1 - 08/03/19 - • Excel VBA .Cells For B...
Video 2 - 22/03/19 - • Excel VBA .Cells For B...
Video 3 - 05/04/19 - • Excel VBA .Cells for B...
Video 4 - 19/04/19 - • Excel VBA .Cells for B...
Playlist link:
tinyurl.com/y4...
These introductory videos will be supported by 'long-play' application videos showing how to apply the technique to real-world problems. These will be viewable in the series playlist when released.
Get in touch with Tiger using the platforms below!
Mailing List
tinyurl.com/yb...
/ tigerspreadsheetsolutions
/ tigspreadsheets
tigerspreadshee...
Also on Insta :-)
Негізгі бет Excel VBA .Cells For Beginners Part 2 of 4
Пікірлер: 13