The Best Tips for Recording Macros in Excel
Вставка
- Опубліковано 2 сер 2024
- Full VBA/Macro Course: www.teachexcel.com/vba-course...
Excel File: www.teachexcel.com/excel-tuto...
Excel Forum: www.teachexcel.com/talk/micro...
This is for the beginner who wants to start learning about how to record macros in Excel and then edit them to work better.
This tutorial, combined with the next one, will get you on your way to building more robust and useful macros in Excel, especially when starting out using the Macro Recorder.
The topics covered here include:
- the most common issues that you will run into when recording a macro
- how to edit a recorded macro
- how to make recorded macros relative so they work on the currently selected cells
- how to record a macro using "relative cell references"
- and also a great tip on how to find out more about the code that is in your recorded macro - this tip will provide you a great tool for further customizing your macro with minimal effort.
Hope you enjoy the tutorial!
TeachExcel.com
This video is gold. Just the "msdn excel vba" tip alone is worth the watch
Glad you like it :)
Agree!
You are godsend. I watch some indian guy on youtube showing how to code shortcut and thought to myself this can't be that difficult then I found you! Thank you.
This tutorial was clear, concise, and informative. Thank you for posting. This will save so much time on the repetitive functions I go through on a daily basis!
Thank you. You are doing the best job in the world: teaching others
Great.. thanks for the tips on recording macros. Thumbs up!
You give me knowledge while I am novice about "excel and macro's" since I discovered you on UA-cam, as Pensioner person I make busy with your lesson and sincerely wishing you all the best...
Thank you for your kind words! I'm really glad I can help :)
Thanks for the vba course - followed the data entry to the end.
amazing :) thanks for your time making this so accessible and easy to follow
Super. A big help. I'm a junior user of macros so this was great! Thanks a lot.
Glad you liked it! Make sure to checkout the tutorial next week to learn the next step in this process :)
Very clear and thank you so much
great one there
chop kiss from Ghana!
All thumbs up for the clear instruction. Already subscribed from 1st lesson. Looking forward to more valuable tutorials. Thank you so much for teaching us 👍
Hi TeachExcel! Thank you for the great tutorials! Are we also able to copy a specific range of cells from a workbook A to B automatically if workbook A has new data input? :)
Good video again.
Your teaching methods are great and helpful to understand macros in basic form. Now I need to practice these methods.
Do you have any videos on a Data Entry Form using info to a saved register with sequential numbers like a certificate numbering system with clients details and device info for example. Dates and phone details also. Best regards and thank you. I viewed some online VBA but most are not complete and I get bugs, debug messages.
Amazing explanation, Thank you
Very good. Thanks.
I became fan of your tutorials and your voice
Thank you for all..
You're very welcome :)
If there were 2 thumbs up I would give it. it just solved what I need to do for my office.
I'm very glad to hear this :D
Great jobs. Simple and easy to follow. Do you have a video that shows how to make a custom form to fill information (data entry).
Thanks! And you bet I do :) ua-cam.com/video/2znSUEn4pyQ/v-deo.html
Excellent you save my life
So good Excel ...
Hi TeachExcel! Thank you for all the great tutorials you do.
Can you help me with this VBA code that I use, "Windows("My File Name.xls").Activate"
I get Excel files sent into me and some have various file extension and I have to rename them before I can enter them into my data form, is it possible to use wild characters such ??? or *
Your help would much appriciated. Cheers.....Don
Hi. Great video. What is the next tutorial that you referred to as combined 'with the next on'?
This was actually harder to figure out than I thought haha. Sorry about that! I think it would have been this tutorial: ua-cam.com/video/Ti1OTJyzedk/v-deo.html
But here is another nice little tip I did for recording macros that you might like: ua-cam.com/video/EKNXo3g6eQU/v-deo.html
@@TeachExcel Thanks
I appreciate that you're using duckduckgo as your search engine 👍
When I downloaded the Tutorial example the files were already formatted meaning I could not follow the video from scratch. The macro was already created and had been used. Please can you include an pre-macro version of the file in the link.
TeachExcel, I use a spreadsheet that I need to covert its tabs into pdf everytime it's used. Thanks to your videos I have started creating different macro buttons which are located/fixed on the spreadsheet. However, I am stuck with one particular idea. Is there a way to create a macro button that opens the pdf converter window without having to go directly to the ribbon?
You shouldn't have to go to the ribbon at all. Go ahead and post the code you're working with so far and your question in our forum and it will be easier to figure out whats up. TeachExcel.com
Why not mention the cursor position on the term, then click "F1" to jump directly into MSDN help in its own window?
Why ween I use record macro to record save as picture a shape it won’t record any steps? I only get sub and end sub.. no code!
Demonstrate the use of macros by recording and then editing a recorded a macro.
Pdf of this experiment
*_John 8.2 Now early in the morning He came again into the temple, and all the people came to Him; and He sat down and taught them. 3 Then the scribes and Pharisees brought to Him a woman caught in adultery. And when they had set her in the midst, 4 they said to Him, “Teacher, this woman was caught in adultery, in the very act. 5 Now Moses, in the law, commanded us that such should be stoned. But what do You say?” 6 This they said, testing Him, that they might have something of which to accuse Him. But Jesus stooped down and wrote on the ground with His finger, as though He did not hear. 7 So when they continued asking Him, He raised Himself up and said to them, “He who is without sin among you, let him throw a stone at her first.” 8 And again He stooped down and wrote on the ground. 9 Then those who heard it, being convicted by their conscience, went out one by one, beginning with the oldest even to the last. And Jesus was left alone, and the woman standing in the midst. 10 When Jesus had raised Himself up and saw no one but the woman, He said to her, “Woman, where are those accusers of yours? Has no one condemned you?” 11 She said, “No one, Lord.” And Jesus said to her, “Neither do I condemn you; go and sin no more.” 12 Then Jesus spoke to them again, saying, “I am the light of the world. He who follows Me shall not walk in darkness, but have the light of life.”_*
_Jesus Christ loves you. Repent and be saved. Only Jesus Christ saves. God bless you, and the grace of the Lord Jesus Christ, and the love of God, and the communion of the Holy Spirit be with you and your family...._