I think it may be important for viewers to know to save their files properly or else if they follow along on excel their information won't save. ALWAYS save the file as Macro-ENABLED which is an *.xlsm file. I lost all my work I going through these the first time.
guess i didn't have the time to say how great you are at tutoring, the lessons are simple to follow and am becoming good...i am building a spread for data analysis used for forex trading.... v.f.l trading too... i know everyone who comes along will definitely give thumbs upppppp........well done...
Dude you're amazing, you know why? You respect the students, these days there are not so many well taught VBA videos and if they are, they are really old, you teach well, edit well and have and incredible personality. New subscriber
I just came across this channel, unlike many others, you are blessed with this great descriptive and simplicity skill. You make complex things simple. That's the real meaning of a "teacher", complex himself but makes complex-simple for others to learn. How I wish I had your personal contact, I could make my projects a great success. God bless!!!
I'm giving this a thumbs up even though you are suggesting that copy and paste coding is not only "OK" it's "A good idea" It's not a good idea. Other than that one major thing, this series is pretty darn good.
Great tuition, step by step, easy to follow explanations. I like the way we're taken straight into the lesson with no sidetracking. See you in video 3 !!
I have pretty much reached the maximum that I can do with formulas and a friend suggested I start learning VB. These were the first videos I found and they are really a wonderful intro. Thank you!
Thank you very much to ''Tiger Spreadsheet Solutions''-as I said before he is absolutely perfect, impeccably flawless and immaculate to the very highest degree! I KNOW every little thing about ''Visual Basic''-I' am now a perfect expert! All these videos are just so absolutely perfect-impeccable/immaculate professionalism, patience, clear and confident presentation!
I am a professional diplomat, ambassador and advocate for impeccable performance within German work, industry and employment. I have been doing for 40 years now. Its just comes with the job.
wow, this is great video because of your teaching techniques. Other videos I've watched I got into 3rd videos and still the guy was talking. You're a great teacher.
Dude... The party don't start til Kyheo walks in ;-) Thanks bro and do check out the other videos, then spread the word if you think they are any good.
Thanks for showing how to do visual basics in excel! I’m already familiar with Visual Basic because I learned it in college but this has helped me learn how to make it more useful!!!
The video was amazing and so easy to follow up. The only problem I had was with copying with ALT key and I made it from the form control directly. Beside this everything was very easy to understand. Thank you!
Mariya - good to hear you were able to master the techniques, including using the Alt key to position objects which is super useful. Do check out the other videos too.
Amazing. The way you are explaining is inspirational. Thank you for the easy way of explaining it. A lot of tutorials even fail to let you know what "Sub" means. Keep up the good work, we are waiting more lessons.
I wish I saw this during my VBA class in college! I am now doing my internship and this is helping me get a recap. Your explanations are easy and simple! Thank you and I've subcribed to your channel :D
Thank sir, its a so useful video for me and others beginner.The video gives me lot for brave and motivation which will be foundation for me...From Bangladesh(Asia)
Very nice videos explained so better than my professors at the university loved how you present information I wished our university profs could learn how to breakdown information for students
Thank you! I just discovered your channel and seen a few videos on VBA, but I'll follow you for a long time, because your explanation is really clear and simple. See you soon!
Great going Sir..!! Pl continue with more advanced concepts citing more such practical examples.That will definitely allow us the privilege of becoming an expert in VBA without attending any classroom training session. Thanks
Hi Cris!Thank you for making all your videos so easy to understand and straight-forward. While I was learning the above tutorial I received an error. ie for the button 'Lower' to be there, I had put in a macro hence it did not take the numeric cell value change. What am I doing wrong here? Thanks in advance!
Hi Roopika - Thanks. It is difficult to tell from your description. Try working through the tutorial again. or send your file to me via the website contact page. Good luck!
Firstly I would like to commend you on a stellar performance with your teachings. I do have a question,and please bear in mind that I am a noob, how do you know what code to use in your Routine. Is this all from experience or is there a guide one needs to study/ Thanx once again Brad
Cheers Brad! And don't worry, we were all noobs once. I find that code makes even experienced practiitioners feel like a noob at least once a day... It comes with experience. I learned first on a Masters course (see My Spreadsheet Story video) which gave me access to a set of resources. I never really referred to the resources, however - trial and error is the best way and all you need to get started is some examples (which you would get from my videos). Having some coding principles in mind is important (but not a 'deal-breaker') - these come through in my videos. But I do not recommend studying a textbook - code should feel like 'play' and the only way to get better at it is to do it. Good luck!
Thanks for sharing . I wonder if I can use Visual Basic in the Developer Tab in MS Word to do the calculation. It is because the calculation in the legacy tools won’t work at all. Appreciate any help.
+Tony Tan Hi Tony - thanks, have you seen the Post-Beginner series, where we apply basic code to speed up an everyday task? th-cam.com/video/Y-8pP_GWnao/w-d-xo.html
+Tiger Spreadsheet Solutions Yes. I am studying your videos every night after work. Would it be possible I can contact you offline to discuss an ongoing of my project used in my work? Thank you
Hi Chris, thanks a mil. Just got started at 74, pretty young to start but am enjoying. Got stuck though - I cannot get the Assign Macro to work.At right clk on the button there is no command there. how can I activate that. i have 10 non pro. thanks. wb
Hi Barry - have you clicked 'enable editing'? Try saving the file to your desktop and opening it from there. Great to hear you've got started with coding and good luck with it!
Thankyou for this. How do I adjust the values without going back into vba. For example, I have set the range to increase by 2. If I wanted to increase by 7 in the same cell do I need to create a new code on a new line to set the range to 7??
Hey, great video. I'm having trouble assigning the macro..the list of available macros doesn't show up. All i get is an empty dialogue box. Ref to 4:56 in your video. I'm not getting the higher, lower, say hello options. I'm facing the same issue in the first video you uploaded
Maha - thank you. I sounds like macros are not enabled, or you have saved the file as .xlsx (which can delete the macros). Start again. - Ensure macros are enabled (Google how) - When you save the file, save to .xlsm (macro-enabled workbook) format I hope this helps and good luck! Chris
I am a senior try to teach other seniors on Mandelbrot set. try to show them plotting the set from Excel through VBA. do you have a video about the subject I like your step by step explanation. thanks.
I thought so. I already have my mind pretty much set on the same. It looks great from a design perspective and I've heard a lot of good things about its graphics and performance as well. Since I don't want to move away from Windows this seems like the obvious choice.
hi, I would like to have button to play selected mp3 files in excel sheet. I mean I need to embed mp3 files so when I click on a button, it play the an mp3 without opening a media player software. Sorry that this is not related to the video as I am starting to learn VBA from this clip only. (a new subscriber)
Hi there, yes, that is possible, using a conditional statement. Check out our conditional statements for beginners series here: th-cam.com/video/RrayWNAR7CM/w-d-xo.html
Hi Waheed. You could try 'activecell.value' to use the value in the selected cell. Using the value in the last clicked cell is possible but difficult and not very useful in terms of educational value. Good luck!
Thanks for the great tutorials. Very straight forward and easy to understand. I wonder if you could help me with something. I'm an English teacher and I've created a Concentration game using Powerpoint 2013. I assigned animation and triggers, and got things to work nicely in that two identical matching squares would disappear simultaneously once a match was found. However, the match basically had to be found the second time you clicked on a particular square regardless of whether a match was found or not because the triggers were set this way. But I then realized that it might take someone numerous attempts, not just two, before actually finding a match and that I probably needed the program so code to link or correlate this squares or fields. Is this something I can do with Powerpoint or is Excel the tool to use. Also, how do I actually go about this. I'd appreciate your help. Thank you!
Anton Pavey Hi Anton - Thank you for the comment, and happy to hear that the videos are helping. Animation is not a strong point of Excel, but I am interested to see if we could build the game. Could you send me your PPT file? I will see how well I can replicate it. You can get in touch via the contact page of the website - tigerspreadsheetsolutions.co.uk/contact-us/
Thanks for your videos, I like the way you explain things in very simple terms. You would make a great excel trainer if you are not already ;-) Thanks again!
Jose Vitoria Many thanks Jose, we appreciate the kind comments. Wishing the best of luck with Excel, and do keep an eye on the channel for more videos this summer...
+Mark Bouwman Hi Mark, I am not an expert on other languages I am afraid. In VBA, however, a routine is a set of coded instructions that Excel executes when asked by the user. Routines are usually triggered by the user clicking a button in the spreadsheet, but can be triggered in other ways too. Hope this helps and good luck.
shahid mahmood Hi there, thank you for the comment. We currently have the four videos in this series on VBA, but more is planned in summer 2015. Do take a look at the other videos in this series. Good luck!
![ค้างคืนโรงเก็บกระสวยอวกาศร้างกลางทะเลทราย [Around The World Ep. 3]](http://i.ytimg.com/vi/E5bWZQhABJE/mqdefault.jpg)
I think it may be important for viewers to know to save their files properly or else if they follow along on excel their information won't save. ALWAYS save the file as Macro-ENABLED which is an *.xlsm file. I lost all my work I going through these the first time.
Yes good point Rachel, thank you.
Thank you very much for this tip!!!!!!!!
Thanks
Excellent. Thank you!
guess i didn't have the time to say how great you are at tutoring, the lessons are simple to follow and am becoming good...i am building a spread for data analysis used for forex trading.... v.f.l trading too...
i know everyone who comes along will definitely give thumbs upppppp........well done...
Kingsley - great to hear about your progress. I have done some forex applications in the past too...
Dude you're amazing, you know why? You respect the students, these days there are not so many well taught VBA videos and if they are, they are really old, you teach well, edit well and have and incredible personality. New subscriber
Menny - thank you for the kind comment! I appreciate it. Please do tell somebody else about the videos. Good to have you on the channel :-)
And don't punch your cat or dog! Only air.
you are a great teacher! keep up the good work.
+Mitchell Schnyder Thanks Mitchell. Keep coding!
I just came across this channel, unlike many others, you are blessed with this great descriptive and simplicity skill. You make complex things simple. That's the real meaning of a "teacher", complex himself but makes complex-simple for others to learn. How I wish I had your personal contact, I could make my projects a great success.
God bless!!!
Thank you very much for the kind comment! I hope you'll enjoy the other videos on the channel too - take care.
I'm giving this a thumbs up even though you are suggesting that copy and paste coding is not only "OK" it's "A good idea"
It's not a good idea.
Other than that one major thing, this series is pretty darn good.
I don’t understand how I didn’t see this video all this years. Unbelievably great work!! Watched all parts of the video!!
Thank you!!!!!!
Thank you my friend and welcome to the channel!
Great tuition, step by step, easy to follow explanations. I like the way we're taken straight into the lesson with no sidetracking. See you in video 3 !!
Thank you my friend - so you there!
I have pretty much reached the maximum that I can do with formulas and a friend suggested I start learning VB. These were the first videos I found and they are really a wonderful intro. Thank you!
Thank you - code is indeed a wonderful thing! Glad to help you get started...
Your explanation is crystal clear.No confusion at all.Thanks to make it so simple.
Good to have you on the channel Raj - thanks!
Thank you very much to ''Tiger Spreadsheet Solutions''-as I said before he is absolutely perfect, impeccably flawless and immaculate to the very highest degree! I KNOW every little thing about ''Visual Basic''-I' am now a perfect expert! All these videos are just so absolutely perfect-impeccable/immaculate professionalism, patience, clear and confident presentation!
You are too generous, my friend, thank you!
I am a professional diplomat, ambassador and advocate for impeccable performance within German work, industry and employment. I have been doing for 40 years now. Its just comes with the job.
You're a natural teacher.....well done!
Many thanks :-)
"Be sure not to punch your dog or your cat." Informative and hilarious
Cheers Adrian! No animals were harmed in the making of this video.
Me : punches computer 😶 SHIT
After watching this I got confidence I can also try macros in Excel. You made it so simple to understand--its a great way to start! Thanks.
Great to hear Vijay - welcome to the channel, I hope you'll keep coming back.
APPRECIATED i HAVE done the visual basic training what you did, Just i was apply by myself and finally it's workout
Thanks and appreciated
You are amazing and good teacher. I have never seen such VBA class on youtube.
Thank you so much and welcome to the channel! See you in the next one ...
one of the coolest way of explaining and teaching things I have ever seen.
Harpaul - many thanks! Please check out the other videos on the channel too.
I am having a marathon in this playlist of urs. Learned alot. Thank you
Great to hear - I hope you enjoy the rest of the videos on the channel!
Just quickly dropping a comment to say that your videos helped me a lot to understand the basics of Excel VBA. Thanks a lot!!
Thanks Marvin - keep up the good work and do share with anybody else you think the videos might help.
wow, this is great video because of your teaching techniques. Other videos I've watched I got into 3rd videos and still the guy was talking. You're a great teacher.
Many thanks Ben - plenty more VBA videos to check out on the channel - enjoy!
I'm late to the party, but dude... You are SUPERCALIFRAGILISTIC!!!!! Wish you were my CFA instructor!!! I definitely subscribed!!!
Dude... The party don't start til Kyheo walks in ;-)
Thanks bro and do check out the other videos, then spread the word if you think they are any good.
These are great! You explain things very well, and teach the "why" as well as the "how."
Many thanks Josh - it's definitely important to understand the context and motivation for the techniques. Good luck with your coding.
Hey there!! Your teaching style is so simple and makes learning easy! Keep it up!
Thanks - good luck with your coding too :-)
Good presentation and easy to understand. You don't go on and on.
Thank you and welcome to the channel
First time I am able to understand VB clearly .. Thanks Guruji !!
Thanks for showing how to do visual basics in excel! I’m already familiar with Visual Basic because I learned it in college but this has helped me learn how to make it more useful!!!
Thanks Navjot, keep up the good work!
your the best TEACHER I HAVE EVER SEE IN MY LIFE keep it up Sir......
Emma - thank you! Please spread the word about the channel...
I was thinking the same thing.
Please make some more (VBA) programming for Excel spreadsheets videos. Your way of teaching is seriously wonderful.
Ah - thank you so much! There are many more videos on the channel for you to enjoy - let me know what you think of them.
Another good video. Once again im in love with the PACE. It's not too fast where I have to rewind 10 x. Great job.
John - pace is important! My brain works in a very manual way so this is my preferred pacing too :-)
Thanks for sharing. finally i found the right channel to understand VB-great explanation indeed.
Thanks Linra - happy to have you on the channel! Plenty more VBA videos to watch...
I am learning from you. Thanks to you my respected Teacher for your nice teaching.
Many thanks Sumit, please do share the tutorials if you find them useful.
The video was amazing and so easy to follow up. The only problem I had was with copying with ALT key and I made it from the form control directly. Beside this everything was very easy to understand. Thank you!
Mariya - good to hear you were able to master the techniques, including using the Alt key to position objects which is super useful. Do check out the other videos too.
I wish I could have given thousand likes! great video for beginners.
I wish I could have found your videos before :) Robin from India
Thanks Robin! Plenty more VBA videos for you to work through. Please do share with somebody else whom you think they would help :-)
Amazing. The way you are explaining is inspirational. Thank you for the easy way of explaining it. A lot of tutorials even fail to let you know what "Sub" means. Keep up the good work, we are waiting more lessons.
Thank you so much! Please do check out the other videos on the channel for more...
I wish I saw this during my VBA class in college! I am now doing my internship and this is helping me get a recap. Your explanations are easy and simple! Thank you and I've subcribed to your channel :D
Good to hear Brian - make sure you tell the other interns about the channel! Good luck.
After being indimidated by VBA for months, this is the first time I am actually able to do this.
Good to hear that the videos are helping you build basic confidence...
Great!!! That how one should explain Macros for beginners. Now I'm full of enthusiasm to learn more.
Good to hear Tarlan! I would recommend our 'VBA for beginners' playlist for more. Good luck!
Thank you! Needed to learn how to do this for my job and it worked!
Brilliant - well done! Do check out the other videos on the channel.
Great Videos. I have learned a lot and hope to learn much more. Thanks for making your videos available.
Great to hear Terry - do check out the other videos on the channel too
Thank you. Saved my day. I cannot believe this is a 9 years old video
Thank you for watching! We've made many more interesting VBA videos in the intervening 9 years ... I hope you'll enjoy a few of them!
You are the best...the monent of truth...punch the air and not others..exited to see the output and sense of achievement...clear explanation thank you
Thank you - please do check out the other video series on the channel. And don't forget to punch the air when it works!
Thank sir, its a so useful video for me and others beginner.The video gives me lot for brave and motivation which will be foundation for me...From Bangladesh(Asia)
Thank you - very happy you feel motivated after watching this. Do check out the other videos on the channel - good luck!
This is awesome video series on interesting topics. Nice teaching techniques. Thank you.
Thank you - please do spread the word about the videos
Very nice videos explained so better than my professors at the university loved how you present information I wished our university profs could learn how to breakdown information for students
Thank you and a big welcome to the channel! Do check out the other videos ...
Thank you! I just discovered your channel and seen a few videos on VBA, but I'll follow you for a long time, because your explanation is really clear and simple. See you soon!
Thanks Mauro - many more VBA videos to work through, enjoy!
Excellent videos; very well explained, clear, simple and perfect pace. Great teaching and thank you for sharing your knowledge.
Many thanks - please do share the videos if they helped you
This is great! Please keep sharing your insights. Thank you
Thanks Lia and good luck with your coding!
"And Excel isn't going to like that" PERFECT
Cheers Jon! Good luck with your coding.
Great going Sir..!! Pl continue with more advanced concepts citing more such practical examples.That will definitely allow us the privilege of becoming an expert in VBA without attending any classroom training session. Thanks
Thanks Shayan! Do check out the other videos on the channel...
Yes for ..sure..!! Would like to know if there are any further videos available apart from the four.
Hi Cris!Thank you for making all your videos so easy to understand and straight-forward. While I was learning the above tutorial I received an error. ie for the button 'Lower' to be there, I had put in a macro hence it did not take the numeric cell value change.
What am I doing wrong here? Thanks in advance!
Hi Roopika - Thanks. It is difficult to tell from your description. Try working through the tutorial again. or send your file to me via the website contact page. Good luck!
Hi Chris! Thanks for the prompt reply :) Sure will try, if still unsuccessful will mail you the file. Thanks again!:)
Thanks Tiger Spreadsheet Solutions for useful video!
Thank you for watching :-)
Great teacher!
Thanks Max, see you in the next video!
Thank you for these videos. I appreciate the help! You are a great teacher.
Many thanks Karen and good to hear the videos helped. Please share with somebody else who might benefit...
Firstly I would like to commend you on a stellar performance with your teachings.
I do have a question,and please bear in mind that I am a noob, how do you know what code to use in your Routine. Is this all from experience or is there a guide one needs to study/
Thanx once again
Brad
Cheers Brad! And don't worry, we were all noobs once. I find that code makes even experienced practiitioners feel like a noob at least once a day...
It comes with experience. I learned first on a Masters course (see My Spreadsheet Story video) which gave me access to a set of resources. I never really referred to the resources, however - trial and error is the best way and all you need to get started is some examples (which you would get from my videos). Having some coding principles in mind is important (but not a 'deal-breaker') - these come through in my videos. But I do not recommend studying a textbook - code should feel like 'play' and the only way to get better at it is to do it. Good luck!
Thanks for sharing . I wonder if I can use Visual Basic in the Developer Tab in MS Word to do the calculation. It is because the calculation in the legacy tools won’t work at all. Appreciate any help.
Hi Sam - it's certainly possible to get VBA to interface with Word, but I'm not an expert, try Google. Good luck!
Thank you so much man. Wonderful and straightforward video!
Many thanks James - please do share it with others if it helped you
@@TigerSpreadsheetSolutions I will most certainly will.
you are a great teacher! keep up the good work. thank you i am from Saudi Arabia
Many thanks - please do share the videos if you find them helpful :-)
Great VDO, easy to understand, easy to follow. Thanks for sharing
Thank You, This opens up a lot of opportunities
Seeing the opportunities is half the battle. It gives you motivation to learn.
love your videos! very easy to understand. I hope you can post more VBA related video clips (case scenario)
thanks again
Tony
+Tony Tan Hi Tony - thanks, have you seen the Post-Beginner series, where we apply basic code to speed up an everyday task?
th-cam.com/video/Y-8pP_GWnao/w-d-xo.html
+Tiger Spreadsheet Solutions Yes. I am studying your videos every night after work. Would it be possible I can contact you offline to discuss an ongoing of my project used in my work? Thank you
Hi Tony, yes, use the website contact page (google Tiger Spreadsheet Solutions) to send us an email, then we can take it from there. Talk soon.
Great Job. you made it look so easy. Thanks a lot.
Many thanks Bob! It gets easier with practice and it was difficult for me at the beginning.
Great videos for a beginner like myself!
Welcome to the channel - many more videos available on VBA
Hi Chris, thanks a mil. Just got started at 74, pretty young to start but am enjoying. Got stuck though - I cannot get the Assign Macro to work.At right clk on the button there is no command there. how can I activate that. i have 10 non pro. thanks. wb
Hi Barry - have you clicked 'enable editing'? Try saving the file to your desktop and opening it from there. Great to hear you've got started with coding and good luck with it!
@5:45 very important info there! xD Was not expecting that with the calm and polite tone you use. So far the videos have been great. Thanks for these!
I still punch the air when it works :-) Great to have you on the channel!
These are great videos! Thanks!
Many thanks Mohamed and welcome to the channel!
Excellent tutorial!! Clear and concise!!
Thanks lots👍🏻
You're welcome - good luck with your coding!
You are a great teacher.
Many thanks Varinia and good luck with your coding :-)
hi thanx for great help. and may I know how will it go in case of alphabets
You're welcome - I am not sure what you mean by alphabets, however?
@@TigerSpreadsheetSolutions i mean letters.
Amazing tutorial, so easy to follow up.
Thanks Jan and a big welcome to the channel!
I love it! You made it look so easy. Great tutorial! ❤
It's a pleasure Mau - please do share the videos with somebody else whom they might help!
this is for providing simple and understandable video easly
thank you and welcome to the channel
You are one of the best teachers.
Thanks Ravinder - good luck with your coding!
Your welcome :)
Yes he is.
I named the button as SayHello, can not click, why, so not new window appear. Why?
Congratulations Mate. The best lessons for beginners!
Thank you sir. Excellent way of teaching.
Thanks Suyog
Thankyou for this. How do I adjust the values without going back into vba. For example, I have set the range to increase by 2. If I wanted to increase by 7 in the same cell do I need to create a new code on a new line to set the range to 7??
Good question - I think we cover this in future videos. You could use a cell to store a value to control the increment, for example.
@@TigerSpreadsheetSolutions Thanks Bud. Can you please copy me in.
I'm so proud of this macro. Thank you! (I punched the table, I assume it won't be mad too long for this)
Great to hear Valentino! Hopefully it is the start of a long coding career! Do check out the other videos on the channel.
Hey, great video. I'm having trouble assigning the macro..the list of available macros doesn't show up. All i get is an empty dialogue box. Ref to 4:56 in your video. I'm not getting the higher, lower, say hello options. I'm facing the same issue in the first video you uploaded
Maha - thank you. I sounds like macros are not enabled, or you have saved the file as .xlsx (which can delete the macros).
Start again.
- Ensure macros are enabled (Google how)
- When you save the file, save to .xlsm (macro-enabled workbook) format
I hope this helps and good luck!
Chris
@@TigerSpreadsheetSolutions I'll try that. Thank you Chris
Good luck!
Simple and effective, seems like i got a personal achievement doing this lol 😂. Thanks sire
Lovely comment - getting code to work is an achievement to be celebrated, I hope it's the start of a long coding career for you.
I am a senior try to teach other seniors on Mandelbrot set. try to show them plotting the set from Excel through VBA. do you have a video about the subject I like your step by step explanation. thanks.
I don't have much about charts, I am afraid. Google is your friend here - good luck ...
I'm wondering which laptop you have? Great set of videos btw.
Hi Ali - thank you. I have, and I highly recommend, the Dell XPS 13.
I thought so. I already have my mind pretty much set on the same. It looks great from a design perspective and I've heard a lot of good things about its graphics and performance as well. Since I don't want to move away from Windows this seems like the obvious choice.
hi, I would like to have button to play selected mp3 files in excel sheet. I mean I need to embed mp3 files so when I click on a button, it play the an mp3 without opening a media player software. Sorry that this is not related to the video as I am starting to learn VBA from this clip only. (a new subscriber)
Best and easy to understand. Bundles of thanks :)
Hi, sir, would like to know is there any way to set maximum and minimum value upon clicking the button?
Hi there, yes, that is possible, using a conditional statement.
Check out our conditional statements for beginners series here:
th-cam.com/video/RrayWNAR7CM/w-d-xo.html
I just love you ! Your method of teaching is par excellent
victim boy - many thanks :-)
That feeling of satisfaction when it works ☺️
It's the best ... and it never fully goes away
hi , thank you
can i edit the code so i can change the value to any selected cell that i choose by clicking on it ... not specific the "e3" cell
Hi Waheed. You could try 'activecell.value' to use the value in the selected cell. Using the value in the last clicked cell is possible but difficult and not very useful in terms of educational value. Good luck!
thats a great thing for beginners,
thanks
It's a pleasure David - do check out the other videos
Thanks for the great tutorials. Very straight forward and easy to understand.
I wonder if you could help me with something.
I'm an English teacher and I've created a Concentration game using Powerpoint 2013. I assigned animation and triggers, and got things to work nicely in that two identical matching squares would disappear simultaneously once a match was found. However, the match basically had to be found the second time you clicked on a particular square regardless of whether a match was found or not because the triggers were set this way. But I then realized that it might take someone numerous attempts, not just two, before actually finding a match and that I probably needed the program so code to link or correlate this squares or fields.
Is this something I can do with Powerpoint or is Excel the tool to use. Also, how do I actually go about this.
I'd appreciate your help. Thank you!
Anton Pavey Hi Anton - Thank you for the comment, and happy to hear that the videos are helping. Animation is not a strong point of Excel, but I am interested to see if we could build the game. Could you send me your PPT file? I will see how well I can replicate it. You can get in touch via the contact page of the website - tigerspreadsheetsolutions.co.uk/contact-us/
Thanks for your videos, I like the way you explain things in very simple terms. You would make a great excel trainer if you are not already ;-) Thanks again!
Jose Vitoria Many thanks Jose, we appreciate the kind comments. Wishing the best of luck with Excel, and do keep an eye on the channel for more videos this summer...
Thanks for your amazing effort, sir i'm trying to create a button that moves the user to another sheet , is this available ?
Waiting for answer
Hi Kittaneh - you're welcome. Use Sheets("SheetName").select to move to another sheet. Good luck!
Amazing Explanation ... Learnt it pretty Easily ... Big Thanks :)
Thanks Harshad... many more coding videos to watch on the channel... good luck!
is a routine the equivalent of a function or a method in a language like c#?
+Mark Bouwman Hi Mark, I am not an expert on other languages I am afraid. In VBA, however, a routine is a set of coded instructions that Excel executes when asked by the user. Routines are usually triggered by the user clicking a button in the spreadsheet, but can be triggered in other ways too. Hope this helps and good luck.
That was so informative. Thank you. do you do tuts for more complex macros.
Vuyani - you are welcome. Check out our VBA for Beginners playlist.
Nicely done - very good at explaining thank you sir
Thank you and good luck with your coding :-)
How did you copy it and Move it? I have tried to do Ctrl P but it did not work. please help
Good presentation....do you have more presentation about VBA...?
shahid mahmood Hi there, thank you for the comment. We currently have the four videos in this series on VBA, but more is planned in summer 2015. Do take a look at the other videos in this series. Good luck!
excellent explanation. thank you
Thank you and welcome to the channel.
I love the video is simple and informative.
Many thanks Karla - please do check out the other VBA videos on the channel :-)
thanks for the video. great tutorial
Thanks and a big welcome to the channel!
Another good video. thank you.
Math Teacher You're welcome Mr Teacher, good luck with your coding!