Introduction to the Visual Basic Editor(VBE)

Excel VBA for Beginners 2- The Visual Basic Editor
2 minutes
Share the link to this page
Copied
  Completed
You need to have access to the item to view this lesson.
One-time Fee
$99.99
List Price:  $139.99
You save:  $40
€88.04
List Price:  €123.26
You save:  €35.22
£75.10
List Price:  £105.15
You save:  £30.04
CA$138.85
List Price:  CA$194.39
You save:  CA$55.54
A$156.01
List Price:  A$218.42
You save:  A$62.41
S$131.39
List Price:  S$183.96
You save:  S$52.56
HK$775.83
List Price:  HK$1,086.20
You save:  HK$310.36
CHF 82.80
List Price:  CHF 115.93
You save:  CHF 33.12
NOK kr1,043.63
List Price:  NOK kr1,461.13
You save:  NOK kr417.49
DKK kr656.84
List Price:  DKK kr919.60
You save:  DKK kr262.76
NZ$167.59
List Price:  NZ$234.64
You save:  NZ$67.04
د.إ367.26
List Price:  د.إ514.18
You save:  د.إ146.92
৳12,148.30
List Price:  ৳17,008.11
You save:  ৳4,859.80
₹8,537.62
List Price:  ₹11,953.01
You save:  ₹3,415.39
RM437.35
List Price:  RM612.31
You save:  RM174.96
₦160,863.91
List Price:  ₦225,215.91
You save:  ₦64,352
₨28,092.19
List Price:  ₨39,330.19
You save:  ₨11,238
฿3,350.66
List Price:  ฿4,691.06
You save:  ฿1,340.39
₺3,841.79
List Price:  ₺5,378.66
You save:  ₺1,536.87
B$568.98
List Price:  B$796.59
You save:  B$227.61
R1,868.66
List Price:  R2,616.20
You save:  R747.54
Лв172.01
List Price:  Лв240.82
You save:  Лв68.81
₩143,821.94
List Price:  ₩201,356.47
You save:  ₩57,534.53
₪362.36
List Price:  ₪507.32
You save:  ₪144.96
₱5,623.93
List Price:  ₱7,873.73
You save:  ₱2,249.79
¥14,366.05
List Price:  ¥20,113.05
You save:  ¥5,746.99
MX$1,950.18
List Price:  MX$2,730.33
You save:  MX$780.15
QR364.06
List Price:  QR509.70
You save:  QR145.64
P1,378.20
List Price:  P1,929.54
You save:  P551.33
KSh12,898.71
List Price:  KSh18,058.71
You save:  KSh5,160
E£5,073.42
List Price:  E£7,102.99
You save:  E£2,029.57
ብር13,121.18
List Price:  ብር18,370.18
You save:  ብር5,249
Kz91,740.82
List Price:  Kz128,440.82
You save:  Kz36,700
CLP$93,485.65
List Price:  CLP$130,883.65
You save:  CLP$37,398
CN¥728.69
List Price:  CN¥1,020.20
You save:  CN¥291.50
RD$5,909.40
List Price:  RD$8,273.40
You save:  RD$2,364
DA13,237.77
List Price:  DA18,533.41
You save:  DA5,295.64
FJ$225.77
List Price:  FJ$316.09
You save:  FJ$90.31
Q770.06
List Price:  Q1,078.12
You save:  Q308.05
GY$20,918.55
List Price:  GY$29,286.80
You save:  GY$8,368.25
ISK kr12,783.72
List Price:  ISK kr17,897.72
You save:  ISK kr5,114
DH925.40
List Price:  DH1,295.60
You save:  DH370.20
L1,725.73
List Price:  L2,416.09
You save:  L690.36
ден5,409.84
List Price:  ден7,573.99
You save:  ден2,164.15
MOP$798.85
List Price:  MOP$1,118.43
You save:  MOP$319.57
N$1,886.91
List Price:  N$2,641.75
You save:  N$754.84
C$3,679.51
List Price:  C$5,151.46
You save:  C$1,471.95
रु13,656.03
List Price:  रु19,119
You save:  रु5,462.96
S/366.91
List Price:  S/513.69
You save:  S/146.78
K405.25
List Price:  K567.37
You save:  K162.12
SAR375.05
List Price:  SAR525.09
You save:  SAR150.03
ZK2,792.07
List Price:  ZK3,909.02
You save:  ZK1,116.94
L438.21
List Price:  L613.52
You save:  L175.30
Kč2,197.59
List Price:  Kč3,076.71
You save:  Kč879.12
Ft35,691.43
List Price:  Ft49,969.43
You save:  Ft14,278
SEK kr968.31
List Price:  SEK kr1,355.67
You save:  SEK kr387.36
ARS$116,356.84
List Price:  ARS$162,904.23
You save:  ARS$46,547.39
Bs690.91
List Price:  Bs967.30
You save:  Bs276.39
COP$424,468.94
List Price:  COP$594,273.50
You save:  COP$169,804.55
₡50,609.75
List Price:  ₡70,855.68
You save:  ₡20,245.92
L2,579.74
List Price:  L3,611.74
You save:  L1,032
₲799,773.34
List Price:  ₲1,119,714.67
You save:  ₲319,941.33
$U4,185.15
List Price:  $U5,859.38
You save:  $U1,674.22
zł375.88
List Price:  zł526.25
You save:  zł150.37
Already have an account? Log In

Transcript

Hey guys, welcome back. So in this video, we're going to have an introduction for the Visual Basic environment. So the Visual Basic environment is where all the coding work is done. This is where we write our code and do a lot of stuff. And we will spend a lot of time during this course, in our Visual Basic environment. So to get to the Visual Basic environment, you can either hit alt n f 11, on your keyboard, or you can go to the developer tab and click on Visual Basic.

And this is the Visual Basic environment. And as you can see here, at the top, we've got a title bar, which says Microsoft Visual Basic for Applications and then it has the name of the workbook VB editor intro. So just like any Windows application, you have a title bar having the title of the application that you've got open, and as you can see here, we've got some menus as well and these menus are the typical menus that we find on almost any Windows application. And we will deal with them as we progress through the course. Also, we will find here a toolbar with some buttons. So we've got here this button that would put us back to the Microsoft Excel environment.

And also this Save button here that can save our work in the Visual Basic environment. So save all the code that we've written. We've got this play button here that runs our code, and some other buttons as well, and we will deal with them. As we progress through the course. We've also got our code window here where we write our code, and we've got our project explorer, which enables you to switch between different projects. And we've also got the properties window here that enables us to change the properties of objects and we will deal with these elements and speak about them as we progress through the course.

As well. So guys, this was a quick overview about the Visual Basic environment. Thank you very much for watching this video and I'll see you on the next one.

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.