VBA Lesson 1 - Intro to VBA Macros - ExcelVBASql.com 25+ hours of FREE training!

www.ExcelVBASql.com

This video explains what a macro is, how to access macros, the VBA environment, subs, and debugging using step into and breakpoints.

Category:

Education

Tags:

• PropertiesWindow
• excel
• macro
• automation
• computer
• office work
• office
• work
• job
• loop
• delete blank cells
• cells
• range
• format
• access
• sql
• sub
• routine
• dim
• variable
• computer programming
• computer science
• excel help
• vba help
• microsoft excel 2007
• training
• tutorial
• Debug
• Toolbar
• Microsoft
• speed
• up
• Object
• Model
• Oriented
• Programming
• OOP
• Objects
• Classes
• VBA
• VB
• Class
• programming
• educational
• microsoft
• vba
• debugging
• EXCEL
• software

[MrKrissh999]

how do i create a userform???

[ExcelVBAHelp]

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

[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

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

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.