Excel VBA Beginner Tutorial - Introduction to the Visual Basic Editor

[blitzinger1]

Please keep cranking these things out. They're so very helpful!

[blitzinger1]

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" ?

[VBA4Excel]

@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.

[nallym82]

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.

[rawdonwaller]

Good vid.

[BGiffin2004]

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.)

[pippaknuckle]

@BGiffin2004 You are joking right?

[ducksaj]

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…

[ducksaj]

… 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?

[THEOUTCASTZ]

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

[Waen2011]

great! I am a beginner ...this is great

[mariokris22]

okay, at last i understand this VB even though still the basic only. i need to work out on my assessment which is a geographic data analysis. though

[MegaNabil96]

hii i have a phonebook application made with vb.net how can i let my excel read the data grid view in the vb.net ??? plz help me

[nathanalo20]

At Last! My First Working Project!

[EArockerful]

Hey bro really good video....Hye I need urgently to solve an Ordinaty diofferential equation by Runge-kuuta 2 and 4....I ahve no idea...pls someone help me!!!

[tomtaylor91uk]

nice work dude

[VBA4Excel]

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

[Liggy2008]

How would you add more text after & Name.. for example, how could i get it to say "Hello " & Name "how are you?", ive tried doing it that way and it doesn't work..?

[ListedBuzz19]

Thank you!