Learning Visual Basic for Microsoft Excel [repost]

Category: Tutorial

Posted on 2016-06-01, by 6_1_9.


Learning Visual Basic for Microsoft Excel
WEBRip | English | MP4 + Project files | 1280 x 720 | AVC ~1200 kbps | 25 fps
AAC | 128 Kbps | 44.1 KHz | 1 channel | 8 hours | 950 MB
Genre: Video Tutorial


In this VB for Excel training course, you will learn how to apply the VBA programming language to make your Excel spreadsheets much more powerful. Seasoned Microsoft trainer Guy Vaccaro starts you out with the basics of VB programming, and teaches you to use it to its fullest potential within Excel.

Guy extends your knowledge past editing odd Macro, directly into creating custom scripts using the VBA Programming Language. This tutorial will teach you about VBA structures, the difference between Functions and Subroutines, how to manipulate Excel Cells, interacting with the user and very importantly, error handling. Designed for the beginner, you do not have to be a programmer already to understand, and implement what you will learn in this software training course.

By the conclusion of this Visual Basic for Excel training course, you will be familiar with the VBA programming language, as it applies to Microsoft Excel. You will be able to apply this knowledge to make interactive and fully functional spreadsheets. Working files are included to let you work alongside the author as you learn VBA for Microsoft Excel in this video tutorial.

Topics include:

01. Getting Started

0101 What Will I Get Out Of This Course
0102 About The Author
0103 The Working Files Explained
0104 What Is VBA?
0105 Excel 2010 Security Settings And Macro Files
0106 The Developer Ribbon

02. Macros

0201 Recording And Running A Simple Macro
0202 Editing An Existing Macro In The Visual Basic Editor
0203 The New Macro Enabled File Type
0204 Quick Tour Of The Visual Basic Editor
0205 Watch A Macro Write Your VBA

03. Procedures And Functions

0301 What Is A Module?
0302 Creating A Sub Procedure Manually
0303 How To Call A Sub Procedure
0304 Creating A Function Procedure
0305 How To Call A Function

04. Getting Started With VBA Programming

0401 Using Comments Within Your VBA Code
0402 Declaring Variables And Data Types
0403 The Scope Of A Variable
0404 The Static Declaration And Variable Expiry
0405 Constants Instead Of Variables
0406 An Intrinsic Constant
0407 String And Date Types Expanded
0408 VBA Operators
0409 Arrays
0410 Multi-Dimensional Arrays
0411 Dynamic Arrays

05. Manipulating Excel Objects

0501 Referencing Cells Using The Range Object
0502 The CELLS Property
0503 The OFFSET Property
0504 The VALUE Of Ranges
0505 The TEXT Object Of The RANGE
0506 A Number Of Read Only RANGE Properties
0507 The FONT Property And Colors
0508 Formatting Numeric Values
0509 Add Formulas To Cells Through VBA Code
0510 Common METHODS Of The RANGE Object

06. Working With Excel VBA Functions

0601 What Is A Function?
0602 Built In VBA Date Functions
0603 Text Manipulation With VBA Functions
0604 Determining File Sizes Using FILELEN
0605 Using Worksheet Excel Functions In VBA Code
0606 User Defined Functions

07. Controlling Program Flow And Execution

0701 Using GOTO And Labels
0702 Controlling The Program Flow With IF THEN ELSE
0703 Multiple Criteria Plus Nested IFs
0704 Adding ELSEIF To Speed Up Execution
0705 SELECT CASE As An Alternative To IF
0706 The FOR NEXT Loop
0707 FOR NEXT With A VBA Collection
0708 DO WHILE Loop

08. Events

0801 How To Create An Event
0802 WorkBook Events - Open
0803 Workbook Events - Closing And Saving
0804 Workbook Triggers - Activate And Deactivate
0805 Worksheet Triggers - Activate And Deactivate
0806 Other Useful Worksheet Triggers
0807 Using Application Events

09. Debugging And Error Handling

0901 Error Trapping the Easy Way
0902 Make The VBA Ignore Errors
0903 Interact With The User When An Error Occurs
0904 Making Use Of The ERR Object
0905 Debugging Techniques
0906 Using Breakpoints To Help Debug
0907 Setup And Use A Watch
0908 Speeding Up The VBA Tips

10. Interacting With Users Through Forms

1001 Using MSGBOX To Interact With Users
1002 Use INPUTBOX For Accepting Values From Users
1003 Selecting A Range With The INPUT Box
1004 An Introduction To UserForms
1005 Creating A UserForm
1006 Using Command Buttons
1007 Adding Option Buttons In A Frame
1008 Adding The Code That Makes The Form Work
1009 Calling Your UserForm And Validating Content
1010 UserForm Controls - The CheckBox
1011 UserForm Controls - ListBox And/Or Combo Box
1012 Images On UserForms
1013 Labels And Text Boxes
1014 Multiple Tabs On A UserForm
1015 Allowing The User To Highlight A Range
1016 Scrollbar And Spin Controls
1017 Controlling Tab Order And Aligning Controls

11. Running And Storing VBA Code

1101 Trigger A Procedure From The Quick Access Toolbar
1102 Customizing The Ribbons
1103 Adding Buttons To Sheets
1104 Adding A Keyboard Shortcut Trigger
1105 Where To Store Your VBA Code
1106 Adding Code To The PERSONAL File

12. Summary

1201 So What's Next?


Complete name : 0105.Excel 2010 Security Settings And Macro Files.mp4
Format : Flash Video
File size : 14.4 MiB
Duration : 3mn 43s
Overall bit rate : 541 Kbps

Format : AVC
Format/Info : Advanced Video Codec
Format profile : Baseline@L3
Format settings, CABAC : No
Format settings, ReFrames : 3 frames
Codec ID : 7
Duration : 3mn 43s
Nominal bit rate : 1 200 Kbps
Width : 1 280 pixels
Height : 720 pixels
Display aspect ratio : 16:9
Frame rate mode : Constant
Frame rate : 25.000 fps
Color space : YUV
Chroma subsampling : 4:2:0
Bit depth : 8 bits
Scan type : Progressive
Bits/(Pixel*Frame) : 0.052
Writing library : x264 core 114 r1913 5fd3dce
Encoding settings : cabac=0 / ref=3 / deblock=1:0:0 / analyse=0x1:0x111 / me=hex / subme=7 / psy=1 / psy_rd=1.00:0.00 / mixed_ref=1 / me_range=16 / chroma_me=1 / trellis=1 / 8x8dct=0 / cqm=0 / deadzone=21,11 / fast_pskip=1 / chroma_qp_offset=-2 / threads=12 / sliced_threads=0 / nr=0 / decimate=1 / interlaced=0 / constrained_intra=0 / bframes=0 / weightp=0 / keyint=250 / keyint_min=25 / scenecut=40 / intra_refresh=0 / rc_lookahead=40 / rc=abr / mbtree=1 / bitrate=1200 / ratetol=1.0 / qcomp=0.60 / qpmin=10 / qpmax=51 / qpstep=4 / ip_ratio=1.41 / aq=1:1.00

Format : AAC
Format/Info : Advanced Audio Codec
Format profile : LC
Codec ID : 10
Duration : 3mn 43s
Channel(s) : 2 channels
Channel(s)_Original : 1 channel
Channel positions : Front: C
Sampling rate : 44.1 KHz
Frame rate : 43.066 fps (1024 spf)
Compression mode : Lossy

Download link






Sponsored High Speed Downloads
8182 dl's @ 3854 KB/s
Download Now [Full Version]
5690 dl's @ 3373 KB/s
Download Link 1 - Fast Download
6555 dl's @ 2726 KB/s
Download Mirror - Direct Download

Search More...
Learning Visual Basic for Microsoft Excel [repost]

Search free ebooks in ebookee.com!

Download this book

No active download links here?
Please check the description for download links if any or do a search to find alternative books.

Related Books


No comments for "Learning Visual Basic for Microsoft Excel [repost]".

    Add Your Comments
    1. Download links and password may be in the description section, read description carefully!
    2. Do a search to find mirrors if no download links or dead links.
    Back to Top