Excel VBA Programming - The Complete Guide [Video]
Video
Video
$178.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
What do you get with video?
What do you get with video?
What do you get with Audiobook?
What do you get with Exam Trainer?
Video
$178.99
Subscription
$15.99
$10 p/m for three months
What do you get with a Packt Subscription?
This book & 7000+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with Video + Subscription?
Download this video in MP4 format, plus a monthly download credit
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with a Packt Subscription?
This book & 6500+ ebooks & video courses on 1000+ technologies
60+ curated reading lists for various learning paths
50+ new titles added every month on new and emerging tech
Early Access to eBooks as they are being written
Personalised content suggestions
Customised display settings for better reading experience
50+ new titles added every month on new and emerging tech
Playlists, Notes and Bookmarks to easily manage your learning
Mobile App with offline access
What do you get with eBook?
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Download this book in EPUB and PDF formats
Access this title in our online reader
DRM FREE - Read whenever, wherever and however you want
Online reader with customised display settings for better reading experience
What do I get with Print?
Get a paperback copy of the book delivered to your specified Address*
Access this title in our online reader
Online reader with customised display settings for better reading experience
What do you get with video?
Download this video in MP4 format
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with video?
Stream this video
Access this title in our online reader
DRM FREE - Watch whenever, wherever and however you want
Online reader with customised display settings for better learning experience
What do you get with Audiobook?
Download a zip folder consisting of audio files (in MP3 Format) along with supplementary PDF
What do you get with Exam Trainer?
Flashcards, Mock exams, Exam Tips, Practice Questions
Access these resources with our interactive certification platform
Mobile compatible-Practice whenever, wherever, however you want
-
Free ChapterGetting Started
-
The Fundamentals of the Excel Object Model
-
The Visual Basic Editor
-
Objects and Methods
-
Variables and Data Types
- Syntax Tips
- Variable Declarations and Assignments
- Multiple Variable Declarations
- The Option Explicit Setting
- The Byte, Integer and Long Data Types
- Mathematical Operations
- The Single and Double Data Types
- The String Data Type
- The Boolean Data Type
- The Date Data Type
- The Variant Data Type
- The Object Data Type
- Default Values for Declared Variables
-
Procedures
-
Object Deep Dive
- The Application Object
- The Application.DisplayAlerts Property
- The Workbooks.Count and Worksheets.Count Properties
- The Workbooks.Open Method and Workbook.Path Property
- The Workbooks.Close Method
- The Workbooks.Add Method
- The Workbook.SaveAs and Workbook.Save Methods
- The Workbook.Activate Method
- The Workbook.Close Method
- The Worksheets.Add Method
- The Worksheet.Visible Property
- The Worksheet.Copy Method
- The Worksheet.Delete Method
- The Worksheet.Move Method
-
Range References
- The Range.Select Method
- The Value vs. Text Properties
- R1C1 Notation, Part I
- R1C1 Notation, Part II
- The Formula and FormulaR1C1 Properties
- The Range.Offset Property
- The Range.Resize Property
- The Cells Property
- The Range.CurrentRegion Property
- The Range.End Property
- The Range.Count and Range.CountLarge Properties
- The Range.Row and Range.Column Properties
- The Range.Rows and Range.Columns Properties
- The Range.EntireRow and Range.EntireColumn Properties
- Get Last Row of Data in Worksheet
-
Range Actions
- The Range.FillDown Method
- The Range.Replace Method
- The Range.TextToColumns Method
- The Range.Worksheet Property
- The Range.Sort Method
- The Range.Font Property
- The Range.Interior Property
- The Range.ColumnWidth and Range.RowHeight Properties
- The Range.AutoFit Method
- The Range.Clear, Range.ClearContents and Range.ClearFormats Methods
- The Range.Delete Method
- The Range.Copy and Range.Cut Methods
- The Paste and PasteSpecial Methods on the Worksheet Object
- The Parent Property on All Objects
-
Conditionals
-
Iteration
-
Miscellaneous Features
-
Arrays
-
Functions
-
Debugging
-
Events
-
User Forms
- Create UserForm, Toolbox, Properties, Controls
- The Label and TextBox Controls
- Naming Conventions
- Design Aesthetics
- The CommandButton Control
- Add Event Procedure to Control
- Unload and Hide a UserForm
- Submit the UserForm
- Activate a UserForm from Procedure
- The initialize Event
- The ListBox Control I - Wire up the Form
- The ListBox Control II - React to User Selection
- The ListBox Control III - Select Multiple Items
- The ComboBox Control I
- The ComboBox Control II
- The CheckBox Control
About this
video
Welcome to Excel VBA Programming–The Complete Guide, the most comprehensive VBA course! Visual Basic for Applications (VBA) is a powerful language built on top of popular Microsoft Office applications such as Excel, Access, and Outlook. It allows developers to write procedures called macros that perform automated actions. Anything that you can do in Excel, you can automate with VBA!
Over the course of more than 18 hours of content, we cover VBA from the ground up, beginning with the fundamentals and proceeding to advanced topics including:
• The Excel Object Model
• The Visual Basic Editor
• Objects and methods
• Variables and data types
• Writing your own procedures
• Workbooks and workbook objects
• Worksheets and worksheet objects
• Range references
• Range actions
• Conditional logic
• Iteration
• Alerts
• Configuring Excel functionality
• Custom functions
• Arrays
• Debugging, even procedures, and user forms
No programming experience is required; complete beginners are more than welcome! VBA is a great language to start with because it lets you master the fundamentals of programming in a familiar work environment. No extra software is necessary: VBA is bundled with all modern versions of Excel. Excel is the World's most popular spreadsheet software and is available on over 750 million computers worldwide. Whether you use it for professional or personal reasons, VBA can help you remove redundancy in your workflows and accelerates your productivity drastically! Thanks for checking out this course!
All the code and supporting files for this course are available at - https://github.com/PacktPublishing/Excel-VBA-Programming---The-Complete-Guide
- Publication date:
- August 2019
- Publisher
- Packt
- Duration
- 17 hours 19 minutes
- ISBN
- 9781839214240
Latest Reviews
(4 reviews total)