VBA Lesson 1 - Intro to VBA Macros - ExcelVBASql.com 31+ hours of FREE Videos!

[saravanan845]

Thanks for your video.. Its really helpful.

[pippaknuckle]

Try not to sniff in your videos, stop recoding, blow your nose, then restart.

[evilsin13]

wow, that was very useful, I am just getting into this now, how do you force open a userform in VBA, for entering values in a table, could you help with the whole set up please?

[MrKrissh999]

how do i create a userform???

[ExcelVBAHelp]

@MrKrissh999 go to ExcelVBASQL [dot] com and watch the lesson on "Userforms"

[MrKrissh999]

Respond to this video... Thanks i found it

[debasishsanyal]

very good ....thanks ....Debasish Sanyal -Hyd 9903525644

[No1DanishPrincess]

Sorry, I ran out of space ;(

1. How to format cell to reflect military time 00:00 (dont need date or seconds).

2. calculate the time dfference between to cells of military time format and return the results into minutes into a 3rd cell/column.

[No1DanishPrincess]

Your Videos are fantastic.- Thank you.

I do however have a problem where I am trying to get excel to:

format time to military time 00:00

calculate the time dfference between to cells of military time format and return the results into minutes.

I have searched everywhere on the net and can't seem to find anything that works. I would be extremely grateful if you would be able to help, perhaps a quick video ... I am sure there are others out there who are as frustrated as i am.

[nitotech]

Do staff accountants use macros?

[ExcelVBAHelp]

@nitotech Yes, staff accounts use macros because most of them use Excel heavily and writing Macros can automate tedious or time consuming tasks from minutes or hours to seconds. Plus if you can write macros it will set you apart from the rest of the accountants who cannot. You can take your job to the next level.

[nitotech]

@ExcelVBAHelp Do you mean basic macros (when you just record it) or when you write the code yourself in visual basic.

[ExcelVBAHelp]

@nitotech Basic recorded macros like the one in this video are good but they cannot be customized so learning to write macros yourself is where people in the industry really set themselves apart. GO to ExcelVBASql [dot] com. We teach you everything you need to know from the basics of macros to writing complete programs. We walk you through the code line by line so check it out. There is over 20+ hours of free video training on macros. ExcelVBASql [dot] com

[nitotech]

@ExcelVBAHelp Wow thanks for the website. Really helpful.

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

thx you very much...

[pansumesh]

Good for beginners

[tahaahmed911]

great video .. it has really helped me !

[yauyau0523]

very nice!! thanks

[abhayny]

That's wonderful for biginners .... thanks a lotttt

[costas020287]

thx



[cdaddi22]

thanks a lot!

[mihirmathur]

dude you sound like Giovanni Ribisi



[nothisworld]

Good job, keep it up



[wallyjazzy]

very nicely done.



[ggauravguptag]

Thanks a lot .....:)

[208885063]

Great Video!

[NYJanus]

Awesome video. Very clear and succinct. Thanks for making the video! I'll be watching the rest of them and hope you continue making more!

[rajathslr]

thank yoooo.....

[nejkoful]

thanks a lot.

[2009jaxs]

I have figured it out. Please disregard my last comment/request, thank you

[2009jaxs]

Great VBA lesson with this video, thank you.

[2009jaxs]

I can use some help, I created a button, I have asigned a macro to that button

The VBA is:

Range("A11:Z13").select

Selection.Copy

Range("A62").select

Activesheet.Paste

Please help me rewrite a code that will upon clicking the button that the macro range A11:Z13 will look for the last data entery in column "F" and then proceed to paste one row below.

I also notice that the outter edges A11:Z13 are flashing, I have to hit ESC key to get rid of it.

I hope I explained it clear enough for someone.

[googlePaladin]

This is the best one on youtube yet. Thanks for creating this example from scratch, I've seen some on youtube where they had a template ready, which I found hard to follow if one doesn't possess the same template. 

[almalhoum]

excellent, thank you

[peterdtrask]

Thanks! Great video and greatly appreciated!

[helaribuska]

real asian women #lushfmlk.info#

[lamevanzi]

good tutorial

[adityavsingh1]

It was nicely explained...

[samatnam]

Dear Editor, my question is; In a worksheet how to find a word; say "total", select all the raw it falls in, plus the two following raws, paste it into a new worksheet, for instance sheet 2. Knowing that the word "total" falls in the first column (A).Many thanks and regards. Kindly reply to (alzaidy@msn.com).

[GmanDaGlitcha]

Very good dude!!!

[mjehan]

very well explained. thank you :)

[ganeshmalai]

Good Video, Thanks

[cjvella177]

Great introductory video. Thanks for posting.

[mdvs2908]

Thank you this was great I'm learning this in Adv Simulation Modeling class for environmental toxicology

[purplesinister]

Very helpful thankyou for the intro

[mrtruthdriven]

thanks for making such an easy to follow lesson

[jagz112]

Fantastic presentation, I know abit, I'm going to follow your lessons and then go and get a qualification thanks alot :)

[chefsamiboy]

good job thanx

[redblue333]

Great job thanks a million!

[f1mercury]

Nice. Veryy clear and easy to follow.

[andoski99]

Nice work... I liked your video

[Giovanni8952]

Im having issues with VBA creating a search with inputbox function and to write other lines, too much detail for here, can someone help please

[obesechicken13]

lol @ the end you say "thanks for the video", yeah no problem. But you made it.

[mucksavage2]

Hi, thanks for taking the time to upload this, its helping me with my thesis.

[koalatotoro]

This is a wonderful guide for people to start off with macro. Thanks for posting such great stuff! :)

[hotnsexyprince]

you are simply amazing ,you are doing huge service to the world at large by making such wonderful videos ,you are the best

[pintusahu2009]

very good u made it simple

[caruv28]

Men Excellent video.. Continue with ur work!!!!!! Excellent!!!

[mustu3]

Wonderful....before this video i though macros was something impossible. U made my life easy mate. Thanks very much.

[SuperMariobrosGalaxy]

Very good

[sivikoo]

Good

[TheAtheistAlliance]

Excellent video, I know what I'll be doing tonight. (I hope it's not sad to enjoy excel)

[dintedengine]

Great vid thanks mate.

[brlinga]

thanks

[coolcat998]

thx

[CharlesLandAssoc]

Thank you....More like this will have me where I can bring something to the table of real value to my employer...

Thanks

[crmason1]

Excellent presentation. I'm a beginner and these types of programs are a huge help. Keep it up!

[zeo996]

Thanks for sharing. I learned a lot.

[boxerhopia]

It is so clear. I'll be following your lessons since I'm a beginner.

Just a suggestion: It might be helpful if you're already teaching us along with the videos the shortcut keys that can be used while doing it so as to familiarize ourselves while jumping up to the next levels.

Thanks much!

[devidkennedy]

Fantastic..

Thank you

[sudhakarp1]

Excellent presentation. Thanks for sharing.

[phinpj]

Fantastic video and clear guidelines, this video helped me to understand VBA, the other tutorials that I watch made it seem more complication. Thank you so much.

[drewjoshd]

thank you