About
LearnDesk
Learn  
Topics
Topics
Topics
Topics
Topics
Topics
Topics
Teach
  Teach Online
  Schedule
  Items
  Billing
  Users
  Marketing
  Analytics
  Settings
  Change School
Account
 

Computer Programming with Excel VBA

Course Introduction
Course Structure and Contents
Preview
Why Learn Excel VBA and SQL?
Writing Your First VBA Program: Hello
Computer Programming Fundamentals
Section Intro
What Is a Computer Program
Computer Language Structure and Elements
Main Data Types
Software Applications Architecture
Quiz: Computer Programming Fundamentals
Summary: Computer Programming Fundamentals
VBA: The Building Blocks
Section Intro
Requirements and Setup
Preview
Getting Familiar with the VBA Editor
Referencing Excel Cells, Ranges
Referencing Rows Columns Worksheets
The Immediate Window
The Excel Object Model, Collections
Properties, Methods, Events
The Macro Recorder
Applying Objects Formatting
Range Selection, Copy, Paste
Assignment 1: Employees Table by Region
Assignment 1 Solution
Data Storage
Preview
Numeric Variables
Non-Numeric Variables
Woking with Excel Objects
Subroutines and Functions
Working with Strings
Working with Dates
Variables Scope and Lifetime
Constants
User Defined Functions
Application Events
Debugging Tools
Quiz: VBA Building Blocks
Section Summary
VBA: Programming Techniques
Section Intro
Conditional Program Flow
Loops
Assignment 2: A Dynamic Certificates Generator
Assignment 2 Solution
1-D Arrays
2-D Arrays
ParamArray
Application Behaviour Control
User Interaction
User Collections
Enumerations
User Defined Types
Data Structures Summary
Error Handling
Preview
Assignment 3: Purchase Orders Enquiary Tool
Assignment 3 Solution - Part 1
Assignment 3 Solution - Part 2
Quiz: VBA Programming
Course Summary: Computer Programming with Excel VBA

Assignment 1 Solution

Computer Programming with Excel VBA VBA: The Building Blocks
By: Mor Sagmon
12 minutes
Share the link to this page
Copied
  Twitter
  Email
Add the class to your calendar
Print
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$97
List Price:  $127
You save:  $30
€90.90
List Price:  €119.02
You save:  €28.11
£77.65
List Price:  £101.67
You save:  £24.01
CA$133.59
List Price:  CA$174.91
You save:  CA$41.31
A$149.65
List Price:  A$195.94
You save:  A$46.28
S$132.36
List Price:  S$173.30
You save:  S$40.93
HK$758.89
List Price:  HK$993.60
You save:  HK$234.70
CHF 89.30
List Price:  CHF 116.92
You save:  CHF 27.61
NOK kr1,076.61
List Price:  NOK kr1,409.58
You save:  NOK kr332.97
DKK kr678.01
List Price:  DKK kr887.71
You save:  DKK kr209.69
NZ$164.67
List Price:  NZ$215.59
You save:  NZ$50.92
د.إ356.27
List Price:  د.إ466.45
You save:  د.إ110.18
৳10,711.96
List Price:  ৳14,024.94
You save:  ৳3,312.97
₹8,097.79
List Price:  ₹10,602.27
You save:  ₹2,504.47
RM462.44
List Price:  RM605.47
You save:  RM143.02
₦128,537.61
List Price:  ₦168,291.51
You save:  ₦39,753.90
₨27,163.85
List Price:  ₨35,565.04
You save:  ₨8,401.19
฿3,603.55
List Price:  ฿4,718.05
You save:  ฿1,114.50
₺3,147.84
List Price:  ₺4,121.40
You save:  ₺973.56
B$503.98
List Price:  B$659.85
You save:  B$155.87
R1,813.16
List Price:  R2,373.94
You save:  R560.77
Лв177.81
List Price:  Лв232.80
You save:  Лв54.99
₩134,428.79
List Price:  ₩176,004.70
You save:  ₩41,575.91
₪362.29
List Price:  ₪474.34
You save:  ₪112.04
₱5,606.84
List Price:  ₱7,340.91
You save:  ₱1,734.07
¥15,318.14
List Price:  ¥20,055.71
You save:  ¥4,737.57
MX$1,660.06
List Price:  MX$2,173.48
You save:  MX$513.42
QR356.61
List Price:  QR466.91
You save:  QR110.29
P1,386.06
List Price:  P1,814.74
You save:  P428.68
KSh12,938.85
List Price:  KSh16,940.56
You save:  KSh4,001.70
E£4,642.74
List Price:  E£6,078.65
You save:  E£1,435.90
ብር5,562.54
List Price:  ብር7,282.92
You save:  ብር1,720.37
Kz80,950.38
List Price:  Kz105,986.58
You save:  Kz25,036.20
CLP$93,269.23
List Price:  CLP$122,115.38
You save:  CLP$28,846.15
CN¥702.37
List Price:  CN¥919.60
You save:  CN¥217.23
RD$5,712.46
List Price:  RD$7,479.21
You save:  RD$1,766.74
DA13,060.66
List Price:  DA17,100.04
You save:  DA4,039.38
FJ$221.69
List Price:  FJ$290.25
You save:  FJ$68.56
Q758.62
List Price:  Q993.25
You save:  Q234.62
GY$20,431.34
List Price:  GY$26,750.31
You save:  GY$6,318.97
ISK kr13,627.53
List Price:  ISK kr17,842.23
You save:  ISK kr4,214.70
DH987.11
List Price:  DH1,292.40
You save:  DH305.29
L1,722.71
List Price:  L2,255.50
You save:  L532.79
ден5,608.35
List Price:  ден7,342.89
You save:  ден1,734.54
MOP$781.77
List Price:  MOP$1,023.55
You save:  MOP$241.78
N$1,823.80
List Price:  N$2,387.87
You save:  N$564.06
C$3,592.79
List Price:  C$4,703.96
You save:  C$1,111.17
रु12,958.20
List Price:  रु16,965.89
You save:  रु4,007.69
S/365.47
List Price:  S/478.50
You save:  S/113.03
K376.91
List Price:  K493.48
You save:  K116.57
SAR363.79
List Price:  SAR476.31
You save:  SAR112.51
ZK2,613.99
List Price:  ZK3,422.45
You save:  ZK808.45
L452.34
List Price:  L592.25
You save:  L139.90
Kč2,287.03
List Price:  Kč2,994.36
You save:  Kč707.33
Ft35,519.84
List Price:  Ft46,505.36
You save:  Ft10,985.52
SEK kr1,068.14
List Price:  SEK kr1,398.49
You save:  SEK kr330.35
ARS$85,508.18
List Price:  ARS$111,954
You save:  ARS$26,445.82
Bs674.75
List Price:  Bs883.43
You save:  Bs208.68
COP$376,235.31
List Price:  COP$492,596.75
You save:  COP$116,361.43
₡49,642.75
List Price:  ₡64,996.17
You save:  ₡15,353.42
L2,411.92
List Price:  L3,157.88
You save:  L745.95
₲729,385.02
List Price:  ₲954,968.02
You save:  ₲225,582.99
$U3,741.84
List Price:  $U4,899.12
You save:  $U1,157.27
zł394.71
List Price:  zł516.79
You save:  zł122.07
Already have an account? Log In
Previous
Next
Home
Search
Saved
Trending Classes
Filter
The latest and the best classes on LearnDesk
Filter by Interest
Close
All Topics
Academics
Business
Creative
Health and Fitness
LifeStyle
Personal Development
Software
Admissions
Engineering
Hardware
Hospitality
Humanities
Chinese
Languages
Maths
Other
Pharma
Research
Science
Social Science
Teaching
Test Preparation
K-12
School
Accounting
Advertising
Analysis
Analytics
Business Communication
eCommerce
Entrepreneurship
Finance
Finance - India
Freelancing
Internet of Things
Digital Transformation
Human Resources
Industry
Management
Marketing
Media
Operations
Other
Project Management
Public Relations
Real Estate
Sales
Strategy
Arts & Crafts
Audio Editing
Audio Production
Dance
Design
Film Production
Music
Photography
Video Production
Writing
Dieting
Fitness
Food Safety
Games
Medical
Medical Professionals
Meditation
Mental Health
Pregnancy
Safety & First Aid
Self Defense
Sports
Beauty & Makeup
Food
Fashion
Gaming
Home Improvement
Parenting
Pet Care & Training
Relationships
Sustainable Living
Travel
Career Development
Learning
Religion and Spirituality
Self-Improvement
Accounting
Amazon Web Services
App Development
Continuous Integration
Backup Software
Business Automation
Computational Fluid Dynamics
Business Intelligence
Computer Aided Design (CAD)
Content Management System
Customer Relationship Management
Database
Data Mining
E-Commerce
Enterprise Asset Management
Enterprise Resource Planning
Game Development
Google Cloud
Linux
Artificial Intelligence
Machine Learning
Master Data Management
Microsoft
Music Software
Network and Security
Open Source
Operating System
Other
Process Management
Productivity Software
Programming Languages
Robotics
Supply Chain Management
Testing
Teaching
Web Development

Sign Up

Sign Up

Share

Share with friends, get 20% off
Invite your friends to LearnDesk learning marketplace. For each purchase they make, you get 20% off (upto $10) on your next purchase.