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.
You give me knowledge while I am novice about "excel and macro's" since I discovered you on RUclips, as Pensioner person I make busy with your lesson and sincerely wishing you all the best...
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!
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 👍
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.
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.
This was actually harder to figure out than I thought haha. Sorry about that! I think it would have been this tutorial: ruclips.net/video/Ti1OTJyzedk/видео.html But here is another nice little tip I did for recording macros that you might like: ruclips.net/video/EKNXo3g6eQU/видео.html
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
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
*_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...._
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.
You give me knowledge while I am novice about "excel and macro's" since I discovered you on RUclips, 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.
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!
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 👍
I became fan of your tutorials and your voice
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
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!
Thank you. You are doing the best job in the world: teaching others
Excellent you save my life
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.
Amazing explanation, Thank you
So good Excel ...
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? :)
great one there
chop kiss from Ghana!
Why not mention the cursor position on the term, then click "F1" to jump directly into MSDN help in its own window?
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 :) ruclips.net/video/2znSUEn4pyQ/видео.html
amazing :) thanks for your time making this so accessible and easy to follow
Demonstrate the use of macros by recording and then editing a recorded a macro.
Pdf of this experiment
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 :)
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.
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: ruclips.net/video/Ti1OTJyzedk/видео.html
But here is another nice little tip I did for recording macros that you might like: ruclips.net/video/EKNXo3g6eQU/видео.html
@@TeachExcel Thanks
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
Very clear and thank you so much
Great.. thanks for the tips on recording macros. Thumbs up!
Very good. Thanks.
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
Thank you for all..
You're very welcome :)
*_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...._