Excel VBA Beginner Tutorial - Introduction to the Visual Basic Editor
Uploader Comments (VBA4Excel)
All Comments (19)
-
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)
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 1 month ago
@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.
VBA4Excel 1 month ago
You need to add an & operator every time you want to combine things together. So it would be "Hello " & Name & " how are you?"
VBA4Excel 2 years ago