This video is gold. Just the "msdn excel vba" tip alone is worth the watch

@TeachExcel

5 жыл бұрын

Glad you like it :)

@jaypeehernandez4029

4 жыл бұрын

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!

Thanks for the vba course - followed the data entry to the end.

You give me knowledge while I am novice about "excel and macro's" since I discovered you on KZread, as Pensioner person I make busy with your lesson and sincerely wishing you all the best...

@TeachExcel

5 жыл бұрын

Thank you for your kind words! I'm really glad I can help :)

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

Thank you. You are doing the best job in the world: teaching others

Great.. thanks for the tips on recording macros. Thumbs up!

If there were 2 thumbs up I would give it. it just solved what I need to do for my office.

@TeachExcel

3 жыл бұрын

I'm very glad to hear this :D

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.

@TeachExcel

5 жыл бұрын

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!

Amazing explanation, Thank you

Very good. Thanks.

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? :)

Excellent you save my life

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.

Thank you for all..

@TeachExcel

5 жыл бұрын

You're very welcome :)

I appreciate that you're using duckduckgo as your search engine 👍

So good Excel ...

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).

@TeachExcel

3 жыл бұрын

Thanks! And you bet I do :) kzread.info/dash/bejne/ZK6itbd-npfWqbQ.html

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

@TeachExcel

3 жыл бұрын

This was actually harder to figure out than I thought haha. Sorry about that! I think it would have been this tutorial: kzread.info/dash/bejne/hp1lsbaDqd3LlM4.html But here is another nice little tip I did for recording macros that you might like: kzread.info/dash/bejne/d3-CutFsl5nLgbg.html

@valentonw772

3 жыл бұрын

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

@TeachExcel

5 жыл бұрын

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 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!

Why not mention the cursor position on the term, then click "F1" to jump directly into MSDN help in its own window?

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...._