Visual Basic for Applications (VBA) for Microsoft Excel: Beyond the Basics

Expand your knowledge of Visual Basic for Applications (VBA) for Microsoft Excel by following along with VBA expert Hassan Khan and master advanced features of VBA.

This hands-on series covers these ten topics:

Using the Relative Reference Option in VBA. Record a macro using the relative reference option in VBA during this first topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session and see how to make your life much easier when creating macros with this option.
Leveraging the Input Box, Message Box, and Active Cell in VBA. Explore the Input Box, Message Box, and Active Cell in VBA during this second topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Referencing Active Cells and Assigning Values to Cells in VBA. Reference active cells and assign values to cells during this third topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Mastering the Immediate Window and Writing Complex Decision Logic in VBA. Master the immediate window and write complex decision logic in VBA during this fourth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Applying Font Changes in VBA. Apply font changes with the help of a VBA macro in this fifth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Applying Border and Alignment Formatting using VBA. Apply border and alignment formatting using VBA in this sixth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Copying and Pasting Data using VBA. Copy and paste data using VBA in this seventh topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Additional Formatting using VBA. Merge, color, wrap text, and change the orientation of the cells using VBA in this eighth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Clearing and Deleting Cells using VBA. Clear and delete cells using VBA in this ninth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.
Inserting and Deleting Rows and Columns using VBA. Insert and delete rows and columns using VBA in this tenth topic in the Visual Basic for Applications (VBA) for Microsoft Excel series. Follow along with Hassan in this hands-on session.