Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Excel VBA Beginner Tutorial - Introduction to the Visual Basic Editor

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
55,198
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Jul 26, 2009

This tutorial provides an introduction to the visual basic editor in excel.

Category:

Howto & Style

Tags:

License:

Standard YouTube License

  • likes, 1 dislikes

Link to this comment:

Share to:

Uploader Comments (VBA4Excel)

  • I understand this stuff well. What I don't understand is where do you learn all the coding commands? Like how would a normal person know to use "MsgBox" ?

  • @blitzinger1 There are a few sources for finding that kind of information out. Firstly Excels built in help can be very useful. If you go to the VBA editor and then press F2 it should open a browser window and take you to the help page

    Second, the object browser in the editor can be very useful. This is accessed by pressing F2 in the editor and list all the available commands with brief descriptions.

    Finally, investing in a good book is an easy way of finding out the useful functions quickly.

  • You need to add an & operator every time you want to combine things together. So it would be "Hello " & Name & " how are you?"

see all

All Comments (19)

Sign In or Sign Up now to post a comment!
  • Please keep cranking these things out. They're so very helpful!

  • @BGiffin2004 You are joking right?

  • Hello VBA4Excel, I really appreciate your effort and these videos are very helpful. But there are only 6 videos. It will be useful if you upload more covering the all basic VBA Thank you.

  • Good vid.

  • I have a hard time trying to understand VBA. Trying to understand that Englishman's accent makes it harder. I have had to rewind to listen to what he is saying half a dozen times in this video, and still didn't get all his words. I know he sounds like that cute gecko on the Geiko commercial - but have him work on his accent for us American folk just trying to learn VBA. Thanks. (I am sure he is probably a nice guy - don't take it personally, guy.)

  • Could you help me plz?? I have a user form and on that form is a textbox.Data from a cell on the worksheet is read into that textbox and the user can observe it. A simple calculation is done on the cell before it is read into the text box.This produces a number with a large number of decimal places. Even though I set the number of decimal…

  • … places of that cell to 2 (via right clicking on the cell and selecting "Format Cells...") the number read into the text box still displays all the decimal places.Could anyone tell me how I can set the number of decimal places of the text box itself?

  • Sorry im new to coding etc. is visual basic case senstitive? (im assuming it is)

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more