If you really want to increase productivity, watch the video on 1.5x speed. And thanks for the upload, it was informative as I didn't know what a macro was prior to watching.
@corgikun2579
4 жыл бұрын
I watch them at 5x
@optimusprime3143
4 жыл бұрын
I watched this vidoe at light speed....
@giftnew2998
4 жыл бұрын
Try this one kzitem.info/news/bejne/p659zpyGi6mXe4Y
@d947
3 жыл бұрын
i watched in in 2x
@Jesse-jb1uo
3 жыл бұрын
@@d947 you’re a legend mate
@prashantd9098
3 жыл бұрын
Your voice and pace is truly amazing and easy to understand, keeps one hooked
@luisalarson8361
Жыл бұрын
Perfect pace and detailed explanations.
@tonycanigo8154
6 жыл бұрын
Man I feel like such a geek but that video got me all pumped up to start learning Macros! For the first time in many years of watching funny birds and pigeons and all kind of sports on youtube I´ll actually subscribe to someone´s channel
@launchexcel
6 жыл бұрын
Hey Tony! Welcome aboard :) Great to know you're pumped up and want to start learning Macros. I'm planning to post more videos soon, so stay tuned!
@nutella_drifter
4 жыл бұрын
I was expecting a good tutorial about macros and I got a great ASMR video as a bonus.
@sreejithpnair8973
4 жыл бұрын
Please Check this Macro too and subscribe kzitem.info/news/bejne/wG5t15qvepaWiaA
@TruthofDilly
6 жыл бұрын
Very helpful...and unlike some people I understand that you were just giving an example of how to use vba ...regardless of whether or not painter would have been better! Thanks mate
@jozefchromy5644
5 жыл бұрын
Like Your calm voice and manner of tutoring - thanks
@SMHo-zb2mi
7 жыл бұрын
Your voice is really soothing and clear. Thank you for your tutorial.
@launchexcel
5 жыл бұрын
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> kzitem.info/news/bejne/rqabyGFohYp-iGU
@user-qt7ol6gk2j
4 жыл бұрын
SUPER !! +Awesome and quite voice for tutorials. Keep it up
@sreejithpnair8973
4 жыл бұрын
Please Check this Macro too and subscribe kzitem.info/news/bejne/wG5t15qvepaWiaA
@DougHaldeman
5 жыл бұрын
This was the best explanation that I've seen for macros. You made it look easy enough that I want to learn it!
@dickyrock1
4 жыл бұрын
Thanks man great video hope there is more.
@sreejithpnair8973
4 жыл бұрын
Check this Macro too and subscribe kzitem.info/news/bejne/wG5t15qvepaWiaA
@liannemarshall8239
5 жыл бұрын
Best learning vid I've seen in ... ever your voice was easy to listen to and the pace was perfect for people trying to learn something new. Most others are sooooo fast you have to keep stopping them and they talk so fast.
@giftnew2998
4 жыл бұрын
Try this one also help you for learn Macro kzitem.info/news/bejne/p659zpyGi6mXe4Y
@sreejithpnair8973
4 жыл бұрын
Please Check this Macro too and subscribe kzitem.info/news/bejne/wG5t15qvepaWiaA
@evi4822
5 жыл бұрын
Thank you. You made it so easy to understand vba. I read books and watch many tutorial videos. But, only your video is the best tutorial.
@andreabennett5077
6 жыл бұрын
the greatest thing is that I understand what you are saying so thank you its important to understand your teacher or you won't learn anything . thank you.
@georgemathai1014
7 жыл бұрын
You're right - I really do see the potential of macros thanks to your video!
@Br0teas
5 жыл бұрын
Great up to the point you changed the zero to a dash.
@launchexcel
5 жыл бұрын
Hi Matthew! It sounds like you don't like having dashes for zeroes. I sometimes like doing that because I find it quicker to identify any zeroes if they are shown as dashes (but that's just my personal preference). Thanks for watching the video!
@Y_Invest
7 жыл бұрын
Wow i'm really impressed of the power of macro's. When my teacher tried to explain this to me, it was all chinese for me. Your explanition is super!! Thans a lot!!
@zhixingliu2904
5 жыл бұрын
Yannickos Es Grande Chinese is very easy for me though XD
@lass-inangeles7564
5 жыл бұрын
Yannickos - EXPLANATION, not EXPLANITION. Yes, quite right. A good teacher makes such a difference.
@giftnew2998
4 жыл бұрын
Try this one also help you for learn Macro kzitem.info/news/bejne/p659zpyGi6mXe4Y
@Pankaj-Verma-
6 жыл бұрын
Great Video. Explained very patiently. Thank you very much for your kind help.
@noueruz-zaman7894
6 жыл бұрын
what an introduction ....best introduction i have seen for any excel video
@shoaibrehman3944
7 жыл бұрын
i am very thankful to you for making me understand the basics of Macros
@blitzwind5678
4 жыл бұрын
great tutorial sir. thank you very much & keep it up
@aquayum72
6 жыл бұрын
Great Video This is especially useful when you're using custom formatting alot. I would then add this to a custom made ribbon so this is done even quicker. Thanks again for your fantasti tip!
@1La2La3La4La
6 жыл бұрын
Thank you for sharing with us. I knew Macros before so wanted to get updated. Beautifully and easily explained.
@anilk6
6 жыл бұрын
Thank you so much. I have at least learnt the basic about macro. It opened lot of this for me in excel. It will certainly help me a lot. MACRO word was like not my piece of cake for many years but I can learn more and more. Its interesting.
@elizabethc4961
7 жыл бұрын
Easy to follow, thanks for sharing this video!
@launchexcel
7 жыл бұрын
Thanks Elizabeth. You can also check out this playlist for more Macros & VBA tutorials: kzitem.info/door/PLjQrfrgBLzJNw1P51nbFVj0GanAa1x8Ju
@lindahuffaker
7 жыл бұрын
Fantastic tutorial! I really needed this! Love the compare to a sports car. Well said!
@deejayblast4me
6 жыл бұрын
Great video. You gained a subscriber. Your tone was calming and your delivery was solid. Thank you for this.
@launchexcel
5 жыл бұрын
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> kzitem.info/news/bejne/rqabyGFohYp-iGU
@yukili912
5 жыл бұрын
Thanks a lot. you are really explained in just right perfect speed and details
@mahmudurhaque7357
5 жыл бұрын
Thank you. It was simple and easy to follow.
@MuhammedsirajM
7 жыл бұрын
thanks for giving a basic understanding about macro.. good job, weather it is appropriate or not for this particular task.
@KeKe0012
7 жыл бұрын
Many thanks for simply breaking it down
@AnthonySmithJosiah
7 жыл бұрын
this is a very good explanation. clear speech and good comparison
@mohansudhir3085
7 жыл бұрын
Excel-lent explanation!!! Thanks you
@sachinsaji4155
5 жыл бұрын
not the place for puns
@shoaibtamboli6986
5 жыл бұрын
@@sachinsaji4155 get some life
@patelvidhu4840
6 жыл бұрын
I like your excel macro tutorial. Thanks.
@sureshparuvolu8835
4 жыл бұрын
Thanks ....really useful.
@sreejithpnair8973
4 жыл бұрын
Check this Macro too and subscribe kzitem.info/news/bejne/wG5t15qvepaWiaA
@kirantherise1
6 жыл бұрын
Excellent, easy to understand.
@maan1277
7 жыл бұрын
Thanks for the wonderful learning.......Now i am able to create macro myself. superlyk for this.
@vtthiang6733
6 жыл бұрын
Ha!Ha! I tried many times learning from the book ExcelVBA Programming for Dummies, but I couldn't get it right. Watching this Video I can get done in a few trials. It works! TQ!
@launchexcel
6 жыл бұрын
Hey VT Thiang - I feel happy to hear my video helped you when the book for Dummies didn't. You can check out my latest VBA videos at this playlist: kzitem.info/door/PLjQrfrgBLzJNw1P51nbFVj0GanAa1x8Ju Cheers - Victor
@darleneevans1513
7 жыл бұрын
Great info. Very clear and understandable
@kasiasoja2687
5 жыл бұрын
Wow, I had no idea that you can do such a thing as record a macro. I always thought that I would have to look online for some special code but no! Thank you for this!
@iraiseyouone
6 жыл бұрын
Thank you. This macro helps when there are empty cells between data (like in accounting spreadsheets) and I don't want to reselect the format button. I just run the macro on specific data and all formatting is done, especially when formatting multiple spreadsheets as the narrator said.
@adrianstanciu1046
6 жыл бұрын
Thank god for youtube's 2x speed options for videos otherwise I would've fallen asleep
@launchexcel
5 жыл бұрын
Hahaha... I totally agreed when I re-listened to this 6 years after recording the original! in fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> kzitem.info/news/bejne/rqabyGFohYp-iGU
@HHHKingofKings58
5 жыл бұрын
You sound like the ads I get for Headspace. 10/10 would do guided meditation with you.
@launchexcel
5 жыл бұрын
Wow... I seem to be gathering a fan base... maybe I should consider setting up a new channel for guided meditation
@kc_cy2022
5 жыл бұрын
For the formatting - red or + blue. U can just right click change the custom format...decimals,$, coma can just use the ribbons at the top toolbar directly
@vincentmcnally3703
6 жыл бұрын
Thank you for the tutorial, it is very informative.
@nebsounds
5 жыл бұрын
Great Tutorial, thanks
@jamesperry3837
7 жыл бұрын
Great ! Huge time-saver. Thank u.
@MazDelaCerna
6 жыл бұрын
This was amazing!! Thanks for sharing! :)
@analyticsautomationwithadv5769
5 жыл бұрын
Take a look at this macro. If you need to split files, this is a nice tool. kzitem.info/news/bejne/kamNyaOmpKOBq6g
@mikemahin
7 жыл бұрын
Good Job. Excellent Tutorial.
@togetherweexcel1525
6 жыл бұрын
Please do check my channel on Excel videos. Thanks :-)
@GunGirlYuna
6 жыл бұрын
Was going to dislike, but ended up watching the whole thing. Good intro.
@navinnarendra3082
7 жыл бұрын
Very Good & Simple Video for Beginners. I am interested in running macro from raw data to Pivot tables. Does it work on recording actions to convert pivot tables every time I have a raw data
@LosNiggaRO
7 жыл бұрын
Your voice is so calming
@togetherweexcel1525
6 жыл бұрын
I agree...
@launchexcel
5 жыл бұрын
Thanks for your comment! In fact I just decided to make a guided sleep meditation video because I agree my voice can be soothing and calming and help people feel sleepy... You can check out my guided sleep meditation videos on my new channel "Be Calm" >>> kzitem.info/news/bejne/rqabyGFohYp-iGU
@ivelisseferrer6920
8 жыл бұрын
Thank you, very explanatory.
@sammyp2155
6 жыл бұрын
Best explanation and introduce to Macro.
@muhammmadibraheem8172
5 жыл бұрын
Wow.................great one.........
@anandkanatti5817
7 жыл бұрын
Thank you for simple demonstration
@hariprasath916
7 жыл бұрын
Explanation to good,.......easy to understand.....
@yolandamkize9076
2 жыл бұрын
Thank youuu so much!
@launchexcel
Жыл бұрын
No problem 😊
@A96000
5 жыл бұрын
Great explanation but you could have just selected all and make the preferred number format. No need for a macro
@shashank2187
5 жыл бұрын
Thanks for your amazing tutorial, really very helpful. A small question have seen some macros where only "Run" option appears in Macro dialog box (6:09). Is there any option to hide our steps?
@tylergable2445
5 жыл бұрын
Alright sweet, time to get my raise and show off.
@puneet16199224
5 жыл бұрын
Brilliant video
@ckhoody169
5 жыл бұрын
Bruh what is Bran Stark doing teaching excel macros
@andyissocool
5 жыл бұрын
The Macro Remembers
@KM-gs2he
5 жыл бұрын
Lol
@erikrowell5820
5 жыл бұрын
bahahahaha
@tylergable2445
5 жыл бұрын
I’m cracking the fuck up hahaha
@mimzem8721
4 жыл бұрын
hahahahahhahah
@ndelpurg
7 жыл бұрын
many thanks please make more excel videos !
@feelingzhakkaas
5 жыл бұрын
Excellent
@soumaj108
5 жыл бұрын
Very helpful
@trivagravia4837
3 жыл бұрын
This is supersonic.
@zaidthunder1
7 жыл бұрын
For this particular task, format painter would be easier than writing a macro.
@MANJEET19891189
7 жыл бұрын
This is just to demonstrate how macro works.... lol
@launchexcel
7 жыл бұрын
Thanks for your comment Zaid. Manjeet's right, this is just a demo of how macros work. In my brand-new video I show how to use Macros to do a simple automation for highlighting formulas, replacing several steps in Excel. Check out my new video "Record Your First Macro in Excel" >> kzitem.info/news/bejne/1Zto1Y2vjZ9pim0
@katarzynaras7042
7 жыл бұрын
sometimes you dont want to use the format painter as changes your collors of the backgroud as well
@brianeid3604
6 жыл бұрын
But if you have 20 or something of those charts to do, macros would be quicker lol
@Valandor_Celestial_Warlock
6 жыл бұрын
I teach basic Excel and was showing a class how to concatenate when one of the students said, "Oh, you can do the same thing by reformatting the cell to 'custom' and blah blah blah." And I said, "This is true but I'm showing you how to concatenate, not customize a cell format." People.
@utupp
6 жыл бұрын
You've earned a sub ma bro! Thanks!
@launchexcel
6 жыл бұрын
Hey bro! Thanks for subscribing to my channel. Hope you learn lots more from me about Excel in upcoming videos. - Victor
@Helpfolder
5 жыл бұрын
I wonder if the Macros work with Google Spreadsheet? Or if they have something similar?
@sunilmane5816
5 жыл бұрын
thanks its very useful
@PacificRanger
3 жыл бұрын
Can this method be applied to copying formula?
@poulomiganguly8486
5 жыл бұрын
Your voice is amazing...feels like I want to know you in-person. 😁
@balasahebpote9517
5 жыл бұрын
Thanks for goodly explanation
@52baldingindianjanitor72
4 жыл бұрын
will you be attending BallmerCon this year?
@sreejithpnair8973
4 жыл бұрын
Check this Macro too and subscribe kzitem.info/news/bejne/wG5t15qvepaWiaA
@alexsy408
5 жыл бұрын
I think there are many Excel shortcuts that are out-of-box that really could be applied here. What about Ctrl+shift+1 or even after setting 1 row in the format you want using F4? Heck you can even highlight the range and all your worksheets and apply the formatting on all worksheets.
@tolanwashington4243
7 жыл бұрын
Excellent demonstration thank you very much
@tdonovan4735
5 жыл бұрын
As you will have the macro in one particular spreadsheet - will it work on all of the other spreadsheets, if you have that one spreadsheet open, or does it have to be replicated in every spreadsheet that you wish to use it in?
@6u5t4v0j1m3n3z
5 жыл бұрын
it depends where you save the macro, if you save it on "this workbook" it will only work on that workbook but if you save it on "personal macro workbook" it will work on any workbook
@yareyare_dechi
5 жыл бұрын
cant you just use the format painter or wasnt this available then/does this work out fast over 100s of operations?
@840083008200
7 жыл бұрын
Thank you Sir this helped me greatly, On my Bucket list is (learn how to use Excel and Macros) I am exactly like your friend do it the slow way. I said to the guys at work the other day does anyone know how to use Macros in Excel surely we can work out a better way to sort number to import into another program R94510, just need to get the number from column B into column A beside R94510,2 as this is how we can import it into the number and quantity.
@MrTeramilna
6 жыл бұрын
Good video i subscribe your channel now for more video I am working in excel most of the time so i always learn new excel skills that useful for me to do my ongoing task on routine basis
@launchexcel
6 жыл бұрын
Muhammad Zahid - Glad to have you as a subscriber! I plan to publish more videos on Macros and VBA soon...
@EchoesOfTheGuiltyy
4 жыл бұрын
We can also paste the format using Crlt+c and then select the whole table crlt+shift+v special paste format
@bertjanspeedfight2
7 жыл бұрын
I need some more info about this! I have to correct all the stock in our stockroom. I use excel for this. But Ive made a mistake. All the products are placed in the C-collumn and the site from the supplier is on the P-collumn. But I want to hyperlink all the C-collumns, so when I click on it, Im directly redirected to the site of the product. But doing that for 2000 items is bit to mutch. So, is it possible to record a macro for this, and how to do this?
@ravekalyan
7 жыл бұрын
very nice
@pritpalsingh953
5 жыл бұрын
Nice ,but what if we wanted to copy and paste it in another excel? Can we do it same way recording and running it?
@sasikumar6309
5 жыл бұрын
Yes
@akilammalika
5 жыл бұрын
Hi, could you kindly share the file with this data so that we can practice along with the video? Thank you :)
@launchexcel
5 жыл бұрын
Hi Malika thanks for your request. Sadly I no longer have the original file because I made this video over 6 years ago. Excel VBA is still the same, still powerful, still very useful. Can I suggest you check out my latest tutorial series which has step-by-step instructions PLUS downloadable workbooks. You can find tutorial #1 here: www.launchexcel.com/getting-started-excel-vba-editor/ Also you might like my website archive page: www.launchexcel.com/archive/#Macros-VBA as it lists all of my Macros and VBA articles to date. Happy learning!
@akilammalika
5 жыл бұрын
Thank you so much! Will definitely check those out! Appreciate it. :)
@satyanarayan-gg2dh
7 жыл бұрын
good stuff thq
@geethass8094
6 жыл бұрын
this was really a very good and a clear explanation😊 wow.. thanku😊
@Hilary44Hilary
4 жыл бұрын
it was great but what if we had many data in one sheet that you couldn't drag the mouse ???
@IhudaBunzl
5 жыл бұрын
under your youtube "how to extract url from hyperlinked cell in excel" you have a link but it does not work...
@Shubham-fe7il
5 жыл бұрын
Zanaaab ho gaya
@rafaeltocan4378
4 жыл бұрын
Good!
@kundanrajak7927
6 жыл бұрын
Thanks for sharing..
@briancastro5123
7 жыл бұрын
Yes but on your video you can highlights all the cell that you want to change the format and do the format number. right? My point, macro isn't really useful in this circumstance.
@swalker3175
7 жыл бұрын
I agree with that. Mind you, if you had to do this for several different tabs over and over then it would be a useful shortcut.
@patriciamanalili4299
7 жыл бұрын
Brian Castro has
@nathanjanus4579
5 жыл бұрын
Is it possible to just take the line of code from two separate macros and create a new macro that does two functions
@mohammady2001
5 жыл бұрын
Excellent way can you give me how I can repeat the macro from to rang
@rakeelmahmood3032
5 жыл бұрын
pretty cool bro
@Tabvincoholic
5 жыл бұрын
Can you suggest how to convert excel in XML using a VBA loaded in a button on the sheet
@optimusprime3143
4 жыл бұрын
Thanku
@moenuddin87
7 жыл бұрын
Hello sir, I need an excell macro tutorial that will automaticaly close my excel workbok after a few times later (Timing)
Пікірлер: 276