You are perfect. I am newb, while i am looking for excel vba source i got you. My own language is not English but even i understand you 80%. Your pronounciation very good for me. Thank you very much and sorry for my bad English.
Pressing Alt while editing the button edges to align it with the cells was something I learned just today and it's amazing I've always wanted to do that! Just started this course and am already enjoying...
You have triggered a big step on my career life as an industrial engineer. With the help of these videos i can make big difference between me and other engineers ; create solid , quick datas and reports. You are a great man!!
Andrew keep up the outstanding work I have no words to describe how grateful I am to have found this channel. You’re a true artist of explanation and VBA
I will have to agree with Freddie, the time and effort you have put forth to help others (like myself, this is EXACTLY what I've been searching for!), is incredible!!!!.....thank you soooo very much.
I have been trying to learn VBA for a long time, I paid a lot of money to get tutorials and and joined classes to get to learn VBA but I never could and I started imagining that I can't do it until yesterday when I found your tutorial #21 and I thought i should give it a go and man I am really enjoying learning it. Now I know I can do it. It is just the teacher that makes difference. I am so thankful for you for delivering the lectures so nicely and easy to understand and WiseOwl for making this wonderful course available for free. Regards Jawad Mansoor
Hi Mr. Andrew. I am working on a program on construction estimates and have been viewing tutorials on VBA. So far your presentation is the best. Simple, very easy to understand. Thank you!
I will really look through every video you've uploaded eventually, as this is a gold mine! I have been using VBA and makro for long, and many many buttons in workbooks, but I did NOT know about the Alt key helping to size the buttons to the grid! That's exactly what I needed! Love your content, much appreciate you sharing so much knowledge in a perfect way!
back again, I have enjoyed ur SQL tutorials as well, and now back again to VBA and still very much interesting and exciting to listen and follow along. Thumbs up
Thank you for such a great tutorial series about Excel VBA. The way you are explaining each subject is easy to follow and makes you go on with the next vid. 10 Points!
Not exciting enough? What's more exciting than being able to make your own custom button icons like a smiley face with a red nose? Why on earth didn't Microsoft decide to keep this mind-blowing functionality? ^_^; Excellent video series, very clearly explained.
Thank you for the well explained tutorials, I must say you have a very pleasant voice which makes it easy to follow, thumbs up! At first I couldn't rename the customized Tab etc. (11:50), but after I closed and reopened the excel I was able to rename. (I use Office 365 2013).
after seeing the videos i have written the programme called .... option explicit Sub wiseowltutorials() 'this is my first excel vba programme Range("A1:Z1000000").Value="YOU ARE AN AWESOME HUMAN BEING" End Sub Thank You so much....
10:00 I did a similar thing into Word: update the entire table of contents (without going to there, clicking the ToC updater and select 'whole ToC'). Works quite good!
Andrew, Have completed the first 5 of the VBA Macro Tutorials. They are very informative and you are a wonderful teacher. I thought your accent would be a problem, but not so. Thanks................ Billy Hanks
Thank you! That was really interesting. However, it would be even more interesting to add another video on how to create/use custom buttons from scratch) Looking forward for this part!
Great videos. One problem I have though is with the QAT for excel 2007. When I add a macro from one workbook it shows up in the QAT in all excel workbooks. As I have many macros I would rather restrict them to an individual workbook, but that doesn't seem to be possible.
Thank you so much for your videos. You are a life saver. Just a quick question: As i opened The VBA sheet, there were already some macros there....How do i delete them? Remove option is not coming for those macros...
Hi, so I've been trying to manipulate some buttons on form I've created and its driving me mad. I want a button to move, in this case up and down, with the height of a label that has text in it. If i give absolute numbers to .top, .left then the button goes exactly where it should. But when i do this in relation to the height of the label the button is nowhere. It goes all over the place. Other buttons on the form work fine. I don't know what i am missing now. The fun is eluding me slightly. Any help appreciated.
Thank you for your useful tutorial! Just have a question: I assigned macro to a button. However when I change computer and open the same file, the button does not work since macro only linked to the location in my original computer. Is there solution to this? Thank you in advance!
Thank you for making these videos - really useful! I was wondering if you could answer a question. Is it possible to modify the keyboard shortcuts for custom tabs? Eg if I make a custom tab called 'macros' and create groups within that tab and populate it with various macros. Can I set the tab shortcut to, let's say, alt-c (the macro-tab I created were set to alt-y1 as default), and then set sub shortcuts for macros within that tab? eg alt-c-1, alt-c-2, alt-c-3 for macros 1, 2, 3, etc. similar to the shortcut structure in the other tabs. Thanks!
Hi, very informative videos. I have a question regarding a finished project. I have created an icon on my quick access toolbar linking to my VBA source, and the program runs well on my computers Excel program. How do i easily transfer this program in one file via email/local network in such a way that multiple other users can simply download this file, customize their quick access toolbar to include my code, and execute my program which will now be permanently featured in the quick access toolbar of my clients Excel?
Hi, I love these videos, so far they are very easy to follow and informative! However I have a problem; I have created a simple macro and it works just fine using either the F5 key or by running it in excel via clicking the Macro button. The problem is I have assigned the macro to a 'picture' I brought into the worksheet. When I click the picture I get the error ' The macro may not be available in this workbook or all macros may be disabled" . I have fully enabled the macro in the macro security settings so im a bit stumped. Im using Excel 2007 and windows 8. Thanks!
Thank you so much for the great tutorial. You are a talented teacher and impacting so many lives. Just one question on customising ribbons - if I customise my ribbon for a specific sheet and email that workbook to someone else, will they be able to use the same customised ribbon tabs for the macros I created on their PC? Would your answer be correct only for one version of Xcel or between different versions? (e.g. I email my workbook 2013 to a user with 2010 or 2007 Xcel. Look forward to hearing from you, Kind Regards
Hello, Your explanations are awesome. I can understand your accent easily. I have few questions to know about macro from you? Where i can post those questions?
Hello, Your courses are fantastic, but the videos do not have translations from English to other languages, and video transcriptions are closed for many videos. Thank you in advance for everything.
HI I want to add some quick access buttons on the upper of excel, however it run out an error says I cannot activate the macro, this macro may not be use in this workbook or might shut down all the macro.
@@WiseOwlTutorials HI dear Good Tutor! thanks a lot for the awesome video, but I wonder if there isn't any automatic way to insert the created VBA code to be run without having the workbook containing the code opened, as other built in toolbars do? It seems to take much time to open the said workbook always. Looking forward to hearing from you.
I kept receiving Error message of Type mismatch at line number 5.Could you please tell me why is this message. I tried to run the same code in another new file it worked while.. may I know what could be wrong exactly? Private Sub Worksheet_Calculate() Dim OPic As Picture Me.Pictures.Visible = False With Range("F4") For Each OPic In Me.Pictures If OPic.Name = .Text Then OPic.Visible = True OPic.Top = .Top OPic.Left = .Left Exit For End If Next OPic End With End Sub
Ribbon buttons don't work for macro execution. The user has his own ribbon his application. You can share your ribbon with him but unfortunately the links will not work because it's looking for a literal file that does not exist as such in the user's computer
Those are excellent videos, but I've been having a issue to understand because you talk too fast. anymay I don't want to be rude, I am just saying it. Thank you.
GAY BOY PARTY 2015 PART 2: THE RECKONING wwwwwwwwoooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo BOOOOOOOOOOOOOOOOOIIIIIIIIIIIIIIIIIIIIIIIII
Hi, so I've been trying to manipulate some buttons on form I've created and its driving me mad. I want a button to move, in this case up and down, with the height of a label that has text in it. If i give absolute numbers to .top, .left then the button goes exactly where it should. But when i do this in relation to the height of the label the button is nowhere. It goes all over the place. Other buttons on the form work fine. I don't know what i am missing now. The fun is eluding me slightly. Any help appreciated.
Hi, Thanks but i got it working. Just in case you're interested here is the code. btnTestYourLuck.Left = LblPages.Left + LblPages.width / 2 - btnTestYourLuck.width / 2 btnTestYourLuck.Top = LblPages.Top + LblPages.Height + btnTestYourLuck.Height + buttonSpace LuckLabel.Left = btnTestYourLuck.Left LuckLabel.Top = btnTestYourLuck.Top + LuckLabel.Height + buttonSpace So this moves a button up and down as the height of a label changes. It also moves another label up and down too. Since i dont know how big the label will be (from 20 characters to over 300) giving absolute references wasnt going to work. Thanks anyway. I do have another problem if you have the time.
***** I have a Timer on a sheet. It increments 1 second at a time as you would expect. The problem is this, I want to show the timer on a form, the same one with the buttons, and so I refer to the cell that the timer is in on the sheet: UserForm1.Label23.Caption = Format(Sheet10.Range("E1").value, "h:mm:ss") When the form loads it recognizes the reference but will not increment in seconds. I had thought that there must be a .refresh method but cannot figure it out. Any ideas.
Each day one Video. I will become an expert in VBA. wonderful Video. God Bless you Andrew
I admire the commitment!
You are perfect. I am newb, while i am looking for excel vba source i got you. My own language is not English but even i understand you 80%. Your pronounciation very good for me. Thank you very much and sorry for my bad English.
Pressing Alt while editing the button edges to align it with the cells was something I learned just today and it's amazing I've always wanted to do that! Just started this course and am already enjoying...
Great series and great video. Can't wait to see what's next.
Thanks Andrew!
I think you and English people in general are so articulate, what a smooth and wonderful presentation.
Your Videos are increasing my productivity at my employment 10 fold. Thank you so much for your excellent teaching style!!!!
You have triggered a big step on my career life as an industrial engineer. With the help of these videos i can make big difference between me and other engineers ; create solid , quick datas and reports.
You are a great man!!
Andrew keep up the outstanding work I have no words to describe how grateful I am to have found this channel. You’re a true artist of explanation and VBA
Thanks again Freddy!
I will have to agree with Freddie, the time and effort you have put forth to help others (like myself, this is EXACTLY what I've been searching for!), is incredible!!!!.....thank you soooo very much.
Thank you for the enormous effort and time in delivering the masterpiece of art. You are a genius.
No, u are actually genius, You should author more books, the way you are going about sequencing the videos is actually really good
I have been trying to learn VBA for a long time, I paid a lot of money to get tutorials and and joined classes to get to learn VBA but I never could and I started imagining that I can't do it until yesterday when I found your tutorial #21 and I thought i should give it a go and man I am really enjoying learning it. Now I know I can do it. It is just the teacher that makes difference.
I am so thankful for you for delivering the lectures so nicely and easy to understand and WiseOwl for making this wonderful course available for free.
Regards
Jawad Mansoor
Hi Mr. Andrew. I am working on a program on construction estimates and have been viewing tutorials on VBA. So far your presentation is the best. Simple, very easy to understand. Thank you!
Thank you very much, People like you make the world a better place :)
you are the best teacher in the world i really enjoying your lesson
I will really look through every video you've uploaded eventually, as this is a gold mine! I have been using VBA and makro for long, and many many buttons in workbooks, but I did NOT know about the Alt key helping to size the buttons to the grid! That's exactly what I needed! Love your content, much appreciate you sharing so much knowledge in a perfect way!
Thank you for the kind words and for watching! I'm happy to hear that you learnt something new!
The best teacher I have ever met!
Andrew you are a genius! Thanks for sharing your immense knowledge 😊
These videos are very helpful and easy to understand. Thank you for uploading them. You are an awesome human being.
back again, I have enjoyed ur SQL tutorials as well, and now back again to VBA and still very much interesting and exciting to listen and follow along. Thumbs up
Thank you for such a great tutorial series about Excel VBA. The way you are explaining each subject is easy to follow and makes you go on with the next vid. 10 Points!
by far the best vba tutorials i have ever seen!
Four videos in and thousands of people have dropped out, sheesh. Tough crowd. This is excellent information.
Not exciting enough? What's more exciting than being able to make your own custom button icons like a smiley face with a red nose? Why on earth didn't Microsoft decide to keep this mind-blowing functionality? ^_^; Excellent video series, very clearly explained.
Great compilation of excel training. You are a perfect teacher.
These are the best tutorials ever made. Thank you so much.
Thank you for the well explained tutorials, I must say you have a very pleasant voice which makes it easy to follow, thumbs up! At first I couldn't rename the customized Tab etc. (11:50), but after I closed and reopened the excel I was able to rename. (I use Office 365 2013).
Very well put down lectures till now. Thanks for your effort
after seeing the videos i have written the programme called ....
option explicit
Sub wiseowltutorials()
'this is my first excel vba programme
Range("A1:Z1000000").Value="YOU ARE AN AWESOME HUMAN BEING"
End Sub
Thank You so much....
10:00 I did a similar thing into Word: update the entire table of contents (without going to there, clicking the ToC updater and select 'whole ToC'). Works quite good!
Thank you so much, you are really great human beings, I am beginner have completed 4 part till now found very easy to understand
I love these videos. So easy to understand.
Simply Genius Lessons! 😃
Thanks! 😀
Amazing video for seemingly simple topic! Thanks for the GREAT tutorials Andrew!
THANK YOU, LEARNED SO MUCH NEW IN THIS ONE, WOW. LOVING IT. WILL GO ALL THE WAY TILL FINISH.
TUSEN TAKK.
This s a good series. Well done
Great stuff. Absolutely easy to follow...
You did a great vba course!!!
You are amazing. Sadly i cant support you financially, but you do an excellent job.
Thanks a lot for brilliant presentations. Great work, Greater Human beings. Be Blessed always. :)
Andrew, Have completed the first 5 of the VBA Macro Tutorials. They are very informative and you are a wonderful teacher. I thought your accent would be a problem, but not so.
Thanks................ Billy Hanks
Andrew doesn't have an accent, you guys are the one's with accents :P
Thank you! That was really interesting. However, it would be even more interesting to add another video on how to create/use custom buttons from scratch) Looking forward for this part!
very comprehensive and informative!!
♥ you are an excel scientist
Best tutorials ever
Thanks! Nice video! Very useful.
Great videos. One problem I have though is with the QAT for excel 2007. When I add a macro from one workbook it shows up in the QAT in all excel workbooks. As I have many macros I would rather restrict them to an individual workbook, but that doesn't seem to be possible.
This video is awesome.
Thank you so much for posting these videos. I've learned so much. :-)
Amazing video! Thanks
Thank you for your effort!
Mind....blown.
God bless you for this help
Thank you so much for your videos. You are a life saver.
Just a quick question: As i opened The VBA sheet, there were already some macros there....How do i delete them?
Remove option is not coming for those macros...
Thank @WiseOwlTutorials
Very cool. Very fun.
macros in quick access and ribbon--nice!
Thank you Thank you for your effort! it very useful.
That smiley at the end :')
thanks for the efforts
Hi, so I've been trying to manipulate some buttons on form I've created and its driving me mad. I want a button to move, in this case up and down, with the height of a label that has text in it. If i give absolute numbers to .top, .left then the button goes exactly where it should. But when i do this in relation to the height of the label the button is nowhere. It goes all over the place. Other buttons on the form work fine.
I don't know what i am missing now. The fun is eluding me slightly. Any help appreciated.
Thank you for your useful tutorial! Just have a question: I assigned macro to a button. However when I change computer and open the same file, the button does not work since macro only linked to the location in my original computer. Is there solution to this? Thank you in advance!
Really great videos.
Quick question, why does it add a sheet each time the macro is ran?
Thanks
Thank you for making these videos - really useful! I was wondering if you could answer a question. Is it possible to modify the keyboard shortcuts for custom tabs? Eg if I make a custom tab called 'macros' and create groups within that tab and populate it with various macros. Can I set the tab shortcut to, let's say, alt-c (the macro-tab I created were set to alt-y1 as default), and then set sub shortcuts for macros within that tab? eg alt-c-1, alt-c-2, alt-c-3 for macros 1, 2, 3, etc. similar to the shortcut structure in the other tabs. Thanks!
do you have any videos on how to put excel programs you have all ready done into Visual Basics
Thanks mate! Very useful
Hi, very informative videos. I have a question regarding a finished project. I have created an icon on my quick access toolbar linking to my VBA source, and the program runs well on my computers Excel program. How do i easily transfer this program in one file via email/local network in such a way that multiple other users can simply download this file, customize their quick access toolbar to include my code, and execute my program which will now be permanently featured in the quick access toolbar of my clients Excel?
In 2016 you can now share your file on cloud and invite how many ppl you want. You can either let them view it or even edit it.
Kurtis Enos unfortunately my office uses office 10 :( . Any solution for this version?
Do you have any videos for Excel 2016 on this subject?
Hi, I love these videos, so far they are very easy to follow and informative! However I have a problem; I have created a simple macro and it works just fine using either the F5 key or by running it in excel via clicking the Macro button. The problem is I have assigned the macro to a 'picture' I brought into the worksheet. When I click the picture I get the error ' The macro may not be available in this workbook or all macros may be disabled" . I have fully enabled the macro in the macro security settings so im a bit stumped. Im using Excel 2007 and windows 8. Thanks!
Looks like you did not assign the macro to the picture. The macro in this case is CreateAndLabelNewSheet, make sure you are assigning correct macro.
Thank you!
Thank you so much for the great tutorial. You are a talented teacher and impacting so many lives.
Just one question on customising ribbons - if I customise my ribbon for a specific sheet and email that workbook to someone else, will they be able to use the same customised ribbon tabs for the macros I created on their PC?
Would your answer be correct only for one version of Xcel or between different versions? (e.g. I email my workbook 2013 to a user with 2010 or 2007 Xcel.
Look forward to hearing from you,
Kind Regards
Hello, Your explanations are awesome. I can understand your accent easily.
I have few questions to know about macro from you? Where i can post those questions?
I was looking for video on debug.print on immediate window..
Hello,
Your courses are fantastic, but the videos do not have translations from English to other languages, and video transcriptions are closed for many videos. Thank you in advance for everything.
cant modify the ribbon name or icon!
HI
I want to add some quick access buttons on the upper of excel, however it run out an error says I cannot activate the macro, this macro may not be use in this workbook or might shut down all the macro.
@@WiseOwlTutorials HI dear Good Tutor! thanks a lot for the awesome video, but I wonder if there isn't any automatic way to insert the created VBA code to be run without having the workbook containing the code opened, as other built in toolbars do? It seems to take much time to open the said workbook always.
Looking forward to hearing from you.
BRIL.LIANT!
Good Video. thank for your kindly
Love your videos man! If only I'd found this earlier! Thank you so much =D
Just wondering if you plan to create similar tutorials for Python?
thank you for sharing
Thank you so much
Hi Andrew. Do you have a plan to create videos on Custom Ribbon using XML?
Hi Imran, that topic is on the list of things to do but I'm not sure when it's going to happen, sorry!
You rock!
I kept receiving Error message of Type mismatch at line number 5.Could you please tell me why is this message. I tried to run the same code in another new file it worked while.. may I know what could be wrong exactly?
Private Sub Worksheet_Calculate()
Dim OPic As Picture
Me.Pictures.Visible = False
With Range("F4")
For Each OPic In Me.Pictures
If OPic.Name = .Text Then
OPic.Visible = True
OPic.Top = .Top
OPic.Left = .Left
Exit For
End If
Next OPic
End With
End Sub
ijoin Ijoin evrybodyIam laso in the group that has befen benefitted from yoroutstanding tutorialst, thankyou
Happy to hear that you found it useful, thanks for watching!
Ribbon buttons don't work for macro execution. The user has his own ribbon his application. You can share your ribbon with him but unfortunately the links will not work because it's looking for a literal file that does not exist as such in the user's computer
very thanks good video
Благодарю!
You get extra points for rolling all the r's :D
0:10
0:36
0:56
Please add English subtitles
Hi there, you can click the CC button at the bottom of the video to switch on Closed Captions. It's not the best translation but it might help!
Those are excellent videos, but I've been having a issue to understand because you talk too fast. anymay I don't want to be rude, I am just saying it.
Thank you.
GAY BOY PARTY 2015 PART 2: THE RECKONING
wwwwwwwwoooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooooo
BOOOOOOOOOOOOOOOOOIIIIIIIIIIIIIIIIIIIIIIIII
Hi, so I've been trying to manipulate some buttons on form I've created and its driving me mad. I want a button to move, in this case up and down, with the height of a label that has text in it. If i give absolute numbers to .top, .left then the button goes exactly where it should. But when i do this in relation to the height of the label the button is nowhere. It goes all over the place. Other buttons on the form work fine.
I don't know what i am missing now. The fun is eluding me slightly. Any help appreciated.
Hi, Thanks but i got it working.
Just in case you're interested here is the code.
btnTestYourLuck.Left = LblPages.Left + LblPages.width / 2 - btnTestYourLuck.width / 2
btnTestYourLuck.Top = LblPages.Top + LblPages.Height + btnTestYourLuck.Height + buttonSpace
LuckLabel.Left = btnTestYourLuck.Left
LuckLabel.Top = btnTestYourLuck.Top + LuckLabel.Height + buttonSpace
So this moves a button up and down as the height of a label changes. It also moves another label up and down too. Since i dont know how big the label will be (from 20 characters to over 300) giving absolute references wasnt going to work. Thanks anyway.
I do have another problem if you have the time.
***** I have a Timer on a sheet. It increments 1 second at a time as you would expect. The problem is this, I want to show the timer on a form, the same one with the buttons, and so I refer to the cell that the timer is in on the sheet:
UserForm1.Label23.Caption = Format(Sheet10.Range("E1").value, "h:mm:ss")
When the form loads it recognizes the reference but will not increment in seconds. I had thought that there must be a .refresh method but cannot figure it out. Any ideas.
***** Thank you very much that works great. Things are going well so far. Just working on the pictures and sound. Thanks again for your help.
***** its a role playing game. With a book. I wanted to try and make an electronic version of the adventure sheet. You can have a look if you like.