Excel VBA Introduction Part 8 - Variables

แชร์
ฝัง
  • เผยแพร่เมื่อ 11 พ.ย. 2024

ความคิดเห็น • 201

  • @reeseagarcia
    @reeseagarcia 8 ปีที่แล้ว +52

    What are Variables? 0:53
    Creating a Non-Declared Variable: 3:06
    Storing Inputbox Results with Variables: 6:19
    A Problem with Non-Declared Variables: 7:59
    Non-Declared vs. Explicitly Declared: 10:59
    Declaring a Variable: 12:32
    Forcing Explicit Declaration: 14:50
    Variable Data Types: 16:31
    Declaring Multiple Variables: 19:11
    The Type Mismatch Error: 22:44
    The Overflow Error: 23:56
    Populating and Manipulating Variables: 25:02
    Variable Scope: 29:12
    Extending the Scope of Variables: 32:48
    Retaining Values in Variables: 35:30

    • @betiryanmercer7301
      @betiryanmercer7301 8 ปีที่แล้ว

      +Reese Garcia Outstanding! Thank you very much. It makes it so easy to find the pieces.

    • @Ericcccc96
      @Ericcccc96 6 ปีที่แล้ว

      Thanks! Gave me a brief but detailed idea abt the episode

  • @mikiring3
    @mikiring3 5 ปีที่แล้ว +4

    This is, by far, the best Excel VBA training video ever.

  • @Rocky-vu3hh
    @Rocky-vu3hh 5 ปีที่แล้ว +4

    I just wanted to express my appreciation for the job you are doing. I cannot emphasize enough how valuable it is to be able to learn from such professionally compiled study material. I am sure, your lessons have improved career path of many people.

  • @AndreaVitiani
    @AndreaVitiani 4 ปีที่แล้ว +1

    The most complete VBA tutorial on TH-cam. Wonderful work

  • @monster2slayer
    @monster2slayer 7 ปีที่แล้ว +1

    i cant believe you are giving these tutorials out for free. such high educational value!
    thank you.

  • @ryanli614
    @ryanli614 10 ปีที่แล้ว +25

    Excellent job Andrew! Very nice and thorough explanation. Thanks for being generous and sacrificing your time to create such educational videos on VBA. Just know that people around the world watching your videos appreciate what you are doing.

  • @jean-polbrasseur9755
    @jean-polbrasseur9755 7 ปีที่แล้ว +1

    Pour l'instant c'est le meilleur tuto VBA que j'ai consulté. Merci pour le travail effectué.

  • @b.petrushchak
    @b.petrushchak 9 ปีที่แล้ว +1

    Thank you for a portion of fresh knowledge on the use of variables of VBA. Your lectures are very good to summarise the knowledge that I learned previously and put everything into its place.

  • @PADRONJORGEL
    @PADRONJORGEL 8 ปีที่แล้ว +1

    Thank you again, is very nice when someone takes its time to explain details to other without rushing

  • @alfsilva
    @alfsilva 9 ปีที่แล้ว

    These are the best Excel VBA tutorials on the net. I have seen tons of related videos but never could actually was able to really grasp the essence of Excel VBA up until now with yours. Congrats and keep up uploading new ones.

  • @maurocastagnera8949
    @maurocastagnera8949 7 ปีที่แล้ว

    I just came to tutorial n. 8 and I've learned so many things about Vba. I do not imagine how many other important and useful things I can learn when I come to the end of the course. I think you are an outstanding teacher!

  • @colina1793
    @colina1793 9 ปีที่แล้ว

    I can really see how this will help in a work context in getting users to follow a flow when entering information into a database. Great series of videos.

  • @andrewnolan180
    @andrewnolan180 3 ปีที่แล้ว +1

    It is shocking how understandable you made the different types of variables. I learned VBA programming a few years back and learned enough to create several complex programs. I never understood variables to the extent I do today after this lesson.

    • @WiseOwlTutorials
      @WiseOwlTutorials  3 ปีที่แล้ว +1

      Thanks Andrew! Happy to hear that you found this one useful, thanks for watching and for your comment!

  • @rodrigofaustino8000
    @rodrigofaustino8000 5 ปีที่แล้ว +1

    You're truly an amazing teacher, mr. Owl. It's a pity that none of my colegues in Brazil will be able to follow this classes due to the lack of english knowledge.... Thank you very much!

  • @Tat-cx1lr
    @Tat-cx1lr 4 ปีที่แล้ว

    C’est toujours un plaisir de revoir vos vidéos. Pour moi vous êtes le NUMBER ONE. Amicalement

  • @kapilmavani2645
    @kapilmavani2645 7 ปีที่แล้ว

    Best VBA training tutorial. Once can start and become expert of VBA through these series of videos. Really nicely explained.

  • @UmamaheshwarAskula
    @UmamaheshwarAskula 10 ปีที่แล้ว

    Best VBA tutorials after searching for months

  • @oysteinoren
    @oysteinoren 10 ปีที่แล้ว

    Just wanted to tell you that you are a great tutor. Thorough with each topic, and concious about structuring the topics in a sensible way.

  • @eothawne7833
    @eothawne7833 8 ปีที่แล้ว +1

    Andrew, your lessons are fantastic. So informative and makes VBA so simple. Great and noble work. Thank you so much!

  • @nikesoccer275
    @nikesoccer275 9 ปีที่แล้ว +1

    Love all of your videos. Very precise, explain everything without being dull and repetitive. Will definitely be continuing through the series. I know the basics, but am still learning a lot with even your most basic tutorials.
    Thank you for making these, it is a great help!!!

  • @stefyuthechosenone1458
    @stefyuthechosenone1458 10 ปีที่แล้ว

    This is an AWESOME serie on VBA !!!! It would be appropriate to remove the word "Introduction" on its title. At least, i learned something in every videos from the first one to the one i'm commenting on. First video was an illumination !!! I was stuck with my Project Explorer et Property tool boxes layed vertically at the top of VBE and you help me to restore the original layout !!! Man that was so huge !!!!!!
    Thanks a lot for your commitment and your kindness to provide for us such valuable tutorials.
    Best regards from France,
    STEPHANE NTONGA

  • @m.mohtashim2000
    @m.mohtashim2000 4 ปีที่แล้ว

    Thank you so much kind sir for teaching so beautifully in a very understandable manner. This is probably the only youtube channel which is providing indepth knowledge about a course for free. I really appreciate your efforts.

  • @analbeadsinmybum
    @analbeadsinmybum 10 ปีที่แล้ว

    Since embarking on my journey to learn vba, I've completely immersed myself in tutorials from tens of different sources. These are by far the best tutorials I've seen and the website is great also. Keep up the good work because it's much appreciated.

  • @briancox5562
    @briancox5562 8 ปีที่แล้ว

    You are just awesome! I have always wanted to understand variables and your video is so thorough, yet simple to understand. Thanks.

  • @naresh1010ful
    @naresh1010ful 4 ปีที่แล้ว

    Hello Sir, thank you for teaching VBA. With the help of your videos im able to learn little basics of VBA.

  • @andreasgruber6740
    @andreasgruber6740 4 ปีที่แล้ว

    I think finally, I understood Variables after watching this. Thank you very much. Excellent explanation!

  • @ashoggcr
    @ashoggcr 7 ปีที่แล้ว

    Excellent tutorials. Clear, concise, informative and helpful. Kind regards from Costa Rica.

  • @olivierbori2570
    @olivierbori2570 6 ปีที่แล้ว +1

    Your courses have helped me to put in order all that I knew from learning on my own.
    I've really liked the shorcuts you give, which I never used before.
    Personally I only use a small part of it all, but it's nice to hear the whole of it.
    As others comments already said, thank you for this brilliant work !
    By the way, The Hobbit is about 3 hours long !

  • @alesloom
    @alesloom 9 ปีที่แล้ว

    i actually benefited from these lessons greatly, 8 days of learning until now
    keep the good work
    thank you very much

  • @freddiejoe5685
    @freddiejoe5685 10 ปีที่แล้ว

    Best VBA tutorials ever .Well articulated and thoughtful process.Well done for saving my job .

  • @datascientistoflife8550
    @datascientistoflife8550 5 ปีที่แล้ว +1

    Sir Thank U so Much for your great work today I make little list and I feel so happy today i learn how to use input box , msgbox, find the last rows, defining variables automatically and credit goes to u sir i struggled so hard u r end I didn't learn anywhere from u only sir..
    Sub howtoInputbox()
    'Multiple Variables
    Dim Emp_lst As String
    Dim Emp_nm As String
    Dim Des As String
    Dim salary As Integer
    Worksheets("Sheet1").Activate
    Emp_lst = InputBox("Enter the Employee in the list")
    Emp_nm = InputBox("Enter the Employee Name")
    Des = InputBox("Enter the Employee Designation")
    salary = InputBox("Enter the Employee Salary")
    Range("A2").End(xlDown).Offset(1, 0).Value = Emp_lst
    Range("B2").End(xlDown).Offset(Range("B2").Rows.Count, 0).Value = Emp_nm
    Range("C2").End(xlDown).Offset(Range("C2").Rows.Count, 0).Value = Des
    Range("D2").End(xlDown).Offset(Range("D2").Rows.Count, 0).Value = salary
    MsgBox "Database" & " " & "Updated "

    • @WiseOwlTutorials
      @WiseOwlTutorials  5 ปีที่แล้ว

      Great work! Happy to hear that the videos have helped you. Well done on writing your own system, great stuff!

  • @helenxu4045
    @helenxu4045 7 ปีที่แล้ว +1

    Great training videos! Better than all other videos/books that I have learnt from! Thanks very much!

  • @minah387
    @minah387 10 ปีที่แล้ว

    Really good and structured, I think if you wanted to pass through a variable (PassVariable) from one sub to another while maintaining the "Locals Window" functionality, you refer to variable between the brackets when you Call the "CalledSub" sub, and refer to it again between the brackets when creating the "CalledSub"
    ex:
    Sub MainSub()
    Dim PassVariable As Integer
    PassVariable = 1
    Call CalledSub(PassVariable)
    End Sub
    -----------------------------
    Sub CalledSub(PassVariable)
    Dim NewVariable As Integer
    NewVariable = PassVariable + 2
    End Sub

  • @chaitanyavemuri1464
    @chaitanyavemuri1464 10 ปีที่แล้ว

    Hi Andrew, This is by far the 'best' & easiest way to Learn.your way to teaching is simply outstanding... I learnt a lot than i learnt from a book ..thank you... Chai

  • @Obitwotwo
    @Obitwotwo 8 ปีที่แล้ว

    Your work adds some much value to the working world!!!! Keep up the great work!

  • @tayfunsenturk2937
    @tayfunsenturk2937 8 ปีที่แล้ว

    what a amazing teacher !!!respect from turkey

  • @ASHWINNS5013
    @ASHWINNS5013 9 ปีที่แล้ว

    You Learn Java and teach all of us just like this.. You are a good Teacher :)

  • @mohdirfancs2004
    @mohdirfancs2004 7 ปีที่แล้ว

    Hi,thanks you wonderful teachings, I am teacher in India learning from you too. most amazing teacher you are I ever seen!!!! :-)

  • @naresh1010ful
    @naresh1010ful 4 ปีที่แล้ว

    In reference to above code, i was able to add movies and all the fields with small changes and yet it worked. I didn't used film id variable to add movies list number ; used offset and it still worked. I would like to share my learning

  • @smartbytesamit
    @smartbytesamit 7 ปีที่แล้ว

    Simply Superb..well explained...videos are designed and named numbered in a structured manner...

  • @TheCodsquallic
    @TheCodsquallic 10 ปีที่แล้ว

    These have to be the best learning videos I've ever seen. Thanks!

  • @dineshra8
    @dineshra8 7 ปีที่แล้ว

    Amazing ,top Quality tutorial and amazing an teacher I have ever seen.. Thank you Andrew from the bottom of my heart.

  • @iamsopure1043
    @iamsopure1043 10 ปีที่แล้ว

    Great VBA series. It really helps especially those debugging techniques. Thank you Andrew.

  • @qudratullahkhan4518
    @qudratullahkhan4518 4 ปีที่แล้ว

    honestly, I didn't see tutorials like these in my four years TH-cam life.

  • @PicknTime
    @PicknTime 9 ปีที่แล้ว +1

    Thanks so much for your videos on VBA. You really make VBA easy.

  • @markmoscosa2371
    @markmoscosa2371 7 ปีที่แล้ว

    Thank you very much, these are Great, Neat and Useful tutorials! Thanks for your time creating them and sharing with us!
    Cheers from Mexico!

  • @Alhusam
    @Alhusam 7 ปีที่แล้ว

    Great channel, great series, great teacher. I look forward to watching the whole set.
    Thank you so much Andrew. You'r really awesome.

  • @TheKhushty
    @TheKhushty 10 ปีที่แล้ว

    Your VBA Tutorials are amazing keep up the good work!!! :D
    Helping me get through my exam which I probably might have failed otherwise!!!

  • @naresh1010ful
    @naresh1010ful 4 ปีที่แล้ว

    Also by practicing these Codes, I understood the importance of placing inputs(code/variables/values) in order.

  • @udusegbe
    @udusegbe 9 ปีที่แล้ว

    I just have to say, really great video tutorials. Well done, Andrew!

  • @stangbien
    @stangbien 10 ปีที่แล้ว +1

    Best VBA tutorials by far, hope there will be a lot more..... a lot!

  • @mansourzanaty691
    @mansourzanaty691 5 ปีที่แล้ว

    Thank you very much for taking the time and effort to make these great videos. I learnt a lot from them.

  • @RanjanTimsina
    @RanjanTimsina 6 ปีที่แล้ว

    You are brilliant. Thank you for educating me on VBA.

  • @kingofdodge3171
    @kingofdodge3171 10 ปีที่แล้ว

    much appreciated videos, im lucky to look for them so soon after release

  • @remarcsd
    @remarcsd 4 ปีที่แล้ว

    In my quest to understand VBA your tutorials stand out as amazingly well structured and coherent. However, on another site the presenter said 'Dim' stood for 'Declare In Memory', which I thought was interesting, but felt was not correct as I had seen it used as short for 'Dimension' (as you state) on very old industrial computers. That said, it's a clever justification for the usage of 'Dim' that does not detract in the slightest from why it is used.

  • @anthonyaguirre6101
    @anthonyaguirre6101 7 ปีที่แล้ว +1

    Just finished the second time around. Thank you, thank you, thank you.

  • @tthamil
    @tthamil 2 ปีที่แล้ว +1

    Thanks!, Ive learned a lot of examples and clear explanation

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 ปีที่แล้ว

      Happy to hear that the video helped you, thanks for watching!

  • @gorflunk
    @gorflunk 7 ปีที่แล้ว

    Your videos are extremely helpful. You have excellent insight as to the questions that must be going on inside the viewer's heads as you step from topic to topic allowing you to answer them accurately before they get too far off track.
    One question that didn't get answered for me, though. No mention of Static variables?

  • @SuNhanDangNgoc
    @SuNhanDangNgoc 8 ปีที่แล้ว

    Such a resourceful and detailed video. Thanks so much for sharing!

  • @TestingPyros
    @TestingPyros 10 ปีที่แล้ว

    This is awesomely awesome stuff! I have wondered how to create inputs, and this has shown me that it's possible! Thanks! I WILL be writing this code today!

    • @TestingPyros
      @TestingPyros 10 ปีที่แล้ว

      *****
      I got the variables and the input boxes, but I need a decimal output on one of them, and it's not giving me that when I ask for it.... On to more to see if THAT question is solved! ;)

    • @TestingPyros
      @TestingPyros 10 ปีที่แล้ว

      I have TestData, but what is double? I can't seem to find that yet.

    • @TestingPyros
      @TestingPyros 10 ปีที่แล้ว

      *****
      You know, GIGO sucks really, really bad sometimes.... I finally went back and looked at my code line by line, and realized I had an extra line for offset, so my final answer was going into a hidden cell.... Ugh.... But! It works correctly, now! ;)

    • @TestingPyros
      @TestingPyros 10 ปีที่แล้ว

      Yep. Now I need to build some "if" statements. NEXT! ;)

  • @parkineson1
    @parkineson1 9 ปีที่แล้ว

    You're the best Andrew!!

  • @sunmittal100
    @sunmittal100 9 ปีที่แล้ว

    Your videos are great. I like the idea of making them more practical rather than theoretical.
    Keep up the good work!
    Just one more thing though... I feel they are a little slow...

  • @johnmulcahy4072
    @johnmulcahy4072 10 ปีที่แล้ว

    Thanks a lot for this lesson. Youve made it so easy for me to understand this stuff. Amazing!!

  • @Howtoexcelatexcel
    @Howtoexcelatexcel 6 ปีที่แล้ว

    Really clear explanation for variables great stuff as ever

  • @cdy23
    @cdy23 9 ปีที่แล้ว

    This is the best channel on TH-cam available to learn Excel VBA in my opinion!
    Excellent job, congratulations and thank you very much!
    How can I contribute to your channel?

  • @tamoghnaacharyya7212
    @tamoghnaacharyya7212 10 ปีที่แล้ว +2

    Thank you for the comprehensive video!!

  • @justinserra9037
    @justinserra9037 10 ปีที่แล้ว

    Wow, Thank you so much. you a great tutor! Really cant stop watching.

  • @Yams070
    @Yams070 9 หลายเดือนก่อน +1

    Thank you so much Andrew 🙏 this helps a lot 😊

    • @WiseOwlTutorials
      @WiseOwlTutorials  9 หลายเดือนก่อน +1

      You're very welcome, thanks for watching!

  • @somanathalegaon9574
    @somanathalegaon9574 9 ปีที่แล้ว

    Great and Awesome tutorial videos..!! Thank you so much for sharing it Andrew...!!

  • @khouidermiloudisk
    @khouidermiloudisk 9 ปีที่แล้ว

    شكرا لكم على المحاضرة القيمة

  • @chriswood2511
    @chriswood2511 10 ปีที่แล้ว +3

    excellent tutorial, way clearer than any other. However noticed the variable doesn't work if you have option explicit at the top

    • @chriswood2511
      @chriswood2511 10 ปีที่แล้ว

      and having watch the whole video I realise why it didn't work!

    • @maziark3861
      @maziark3861 10 ปีที่แล้ว

      Chris Wood
      Oh Man! Thanks for mentioning it! I have always been stuck with my variables. Once I found a way by defining for example "Dim X as Integer" and then X=...
      Never knew it's because of Option Explicit at the top. Well I haven't watched the whole video yet. But sofar, you saved my life :)
      I would also like to take the opportunity to thank Andrew ***** for the super awesome tutorials... It motivates me to start SQL after VBA. He is the best tutor ever.

    • @nicholascontelmo349
      @nicholascontelmo349 10 ปีที่แล้ว

      Good God, took me forever to figure that out. Thankfully I saw your comment

  • @ratl0ver3
    @ratl0ver3 8 ปีที่แล้ว

    Incredibly clear. Thank you!

  • @luigirazzetti7945
    @luigirazzetti7945 7 ปีที่แล้ว

    Very and very nice videos...greetings from Italy

  • @rahulvarshney2469
    @rahulvarshney2469 10 ปีที่แล้ว +1

    Thanks very much! Where can I find the source files that you use so I can follow along?

  • @ashermatthew873
    @ashermatthew873 5 ปีที่แล้ว +1

    the NewFilmName thing isn't working for me.
    Does anyone else have this problem?
    I followed Andrew's instructions to a T, but it's still not working

    • @fuzzthemutt
      @fuzzthemutt 5 ปีที่แล้ว

      Do you have the "option explicit" enabled still? That was my issue.
      "Once you've included the Option Explicit statement in a module, Visual Basic for Applications doesn't execute a procedure inside that module unless absolutely all the variables within that procedure are declared.

  • @prachisawant2614
    @prachisawant2614 7 ปีที่แล้ว +2

    Thanks you so much for amazing tutorials... you are really amazing

  • @KOURK78
    @KOURK78 8 ปีที่แล้ว

    Perfect tutorials. Million thanks for helping!!

  • @exp3905
    @exp3905 9 ปีที่แล้ว

    I'm learning a lot. Thank you very much!

  • @binwang7486
    @binwang7486 8 ปีที่แล้ว

    Great lessons, thank you so much! It has been really helpful!

  • @jerhummemarcelo7194
    @jerhummemarcelo7194 8 ปีที่แล้ว +1

    hi andrew thanks for the amazing lesson here. I'm just wondering how to reset global variables with out closing the entire work book. thank you very much and God bless

    • @ngalimdestain6070
      @ngalimdestain6070 5 ปีที่แล้ว

      Set Public variables to Zero before the sub ends

  • @bognarandras8398
    @bognarandras8398 4 ปีที่แล้ว

    Very nice, anybody knows what shortcut he used for the indenting at 33:19 ?

  • @novaseewald4093
    @novaseewald4093 9 ปีที่แล้ว +2

    Greetings from Denver, Colorado :-)
    Thank you for the awesome tutorial! I've watched several videos by others, but you made it a lot easier to understand.
    I do have a question, Why split a subroutine if it's getting long? Is it easier to navigate through?
    Thank you

    • @ngalimdestain6070
      @ngalimdestain6070 5 ปีที่แล้ว

      In order to call on specific actions bit by bit

  • @TheRealMake-Make
    @TheRealMake-Make 9 ปีที่แล้ว

    Hahaha! 24:35...
    Nice work, sir! You have made my career.

  • @stefyuthechosenone1458
    @stefyuthechosenone1458 10 ปีที่แล้ว

    i mean horizontally rather than vertically !!!! For the sake of being detail-oriented and precise.
    Thanks !!!!!!

  • @thekarthikkundapur
    @thekarthikkundapur 8 ปีที่แล้ว

    Great work, well explained, Thank you for your videos!

  • @alaakhatab8840
    @alaakhatab8840 7 ปีที่แล้ว

    Thanks for your great efforts and again thanks for sharing this great value

  • @prydama
    @prydama 9 ปีที่แล้ว +1

    First I say thank you for your very system tutorial. I could not find the better tutor than you explained as well. Yet, I have two question, let say I have value in B1, then I need to select a cell below B1. I tried to use range("B1").end(xldown).offset(1,0).select, but it didn't work. Please give me solution. The second question is how to set numberin code, let say i need to input number and film name in cell A2 and B2 respectively (the top range (A1:B1) is label). I could not write the code how to increment the number, because I could not add integer type by string type. It looks hard to explain this problem, hopefully you can understand. Thank you Mr. Andrew Gould.

    • @prydama
      @prydama 9 ปีที่แล้ว

      +WiseOwlTutorials thank you. But anyway, I already watched your tutorials until part 22, where can I find the tutorials explaining about worksheetfunction?

    • @prydama
      @prydama 9 ปีที่แล้ว

      I see. Sadly, I really need course about it. Anyway, you are the best programming teacher I ever met. Thank you Andrew.

    • @djlotusak6820
      @djlotusak6820 6 ปีที่แล้ว

      very good point to make this work if you don't have any values at the beginning

  • @sophieut131
    @sophieut131 8 ปีที่แล้ว

    Your Videos are great! Thank you so much

  • @g121evilroom
    @g121evilroom 10 ปีที่แล้ว

    Hey ! Amazing videos really helpful....Just one question, I saw you entered the date as 8 Nov 2013. At 21:59 I saw that the date was saved in the variable in the dd/mm/yyyy format. Will it always save in this format and not the american way of mm/dd/yyyy ? Thanks !

  • @meihan7244
    @meihan7244 10 ปีที่แล้ว

    Really good and lots of information! Thank you very much! One question, do you happen to know if VBA is supported in Office 365 or Office 2013, especially if it runs in tablets with Window 8.1 system and Office 365? Thanks.

    • @meihan7244
      @meihan7244 10 ปีที่แล้ว

      ***** Thanks!

  • @PMehr
    @PMehr 9 ปีที่แล้ว +1

    Awesome videos so far, Andrew. I am doing everything simultaneously on my computer, which helps a lot. Just one question remained after this video:
    At minute 33:16 you remove the indenting with a shortcut after selecting the lines with you mouse. Which shortcut is that? Thanks in advance!

  • @gurpritsingh11
    @gurpritsingh11 3 ปีที่แล้ว +1

    You are gem brother

  • @abada2007
    @abada2007 4 ปีที่แล้ว +1

    really great video tutorials

  • @harunhodzic1
    @harunhodzic1 6 ปีที่แล้ว

    Hello again
    I try to solve one dimensional cutting stock problem with excel solver but I have problem with constraints. When solver is finished its show just one optimal solution but I try to make every posible optimal solution for diferent cut lenghts and number of cuts. I think that some loops or something like that is answer but how to do it ...
    Thanks

  • @jomipurayidam
    @jomipurayidam 10 ปีที่แล้ว

    Thank you for this lecture series

  • @raffaellostarace4684
    @raffaellostarace4684 9 ปีที่แล้ว

    Thank you very much Andrew!! I have just one issue -- the IntelliSense does not show up when I press Ctrl + Space . Do you know how I can fix this?

    • @Yodalearning
      @Yodalearning 9 ปีที่แล้ว

      ***** Ctrl + J helps

  • @acdcvotu
    @acdcvotu 2 ปีที่แล้ว

    Funny date variable value... In previous tutorials, WiseOwl mentioned that VBA reads dates in USA format (ex: if you parse '#08 Nov 2013#', VBA code would show '11/8/2013'). BUT at 21:57, Locals shows that the value of FilmDate expression is #08/11/2013# (UK-date format)... Is that right?

    • @WiseOwlTutorials
      @WiseOwlTutorials  2 ปีที่แล้ว +1

      Hi Rafael! Yes, that's right - dates that you enter in the code window are always shown as #mm/dd/yyyy# (as far as I know) but the Locals Window, Immediate Window (when using Debug.Print) and front end things like MsgBox and the actual Excel worksheet will use your regional settings.
      I hope that helps!

  • @freshcallow7548
    @freshcallow7548 10 ปีที่แล้ว

    Awesome work, great help !
    Thank you sir.

  • @yanalapazao6919
    @yanalapazao6919 10 ปีที่แล้ว

    You are amazing...greetings from Germany!!!

    • @yanalapazao6919
      @yanalapazao6919 10 ปีที่แล้ว

      Can you also do tutorials in C/C++??

  • @hansholzer2667
    @hansholzer2667 9 ปีที่แล้ว

    very well explained, thanks!

    • @hansholzer2667
      @hansholzer2667 9 ปีที่แล้ว

      Yes, indeed i will thank you again as i'm just going through all your Introduction course and suddenly actually start understanding what i'm doing... So that's really great.