Excel VBA Introduction Part 53.1 - Working with Strings

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

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

  • @frikduplessis8849
    @frikduplessis8849 3 ปีที่แล้ว +2

    Thank you Andrew this is a awesome tutorial I don't know how on earth I missed this one,

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

      Thanks so much Frik, happy to hear that you enjoyed it!

  • @shmred5705
    @shmred5705 7 ปีที่แล้ว +3

    Becoming good at vba AND random movie information. Great job!

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

    Hands down, the Best series on VBA that I have come across on the internet... Andrew, you sir, are awesome! (and I am loving all your twilight jokes throughout this series :P)

  • @setukansara
    @setukansara 7 ปีที่แล้ว +4

    Looking forward to see the next video 53.2... Thank you.

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

      I absolutely look forward to your videos.

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

      @@WiseOwlTutorials No i dont think so, these videos are really excellent and provide a lot of very useful examples. So a huge thank you for all the effort !

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

    thank you very much for this video! Apart from working with strings you have also showed the Object browser, which I find it very helpful for every type of object.

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

      Thanks for the comment and for watching, Albert!

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

    Thanks for sharing your knowledge. You previously mentioned that their is a book in the works, if so, I can't wait to purchase it!

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

    Thanks a lot. This definetly helps me to optimize some of my older procedures. Great tutorial!!!

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

    That was a really fun video
    Thank you.

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

      Glad you enjoyed it, thanks for taking the time to comment!

  • @AmitSharma-po1zb
    @AmitSharma-po1zb 4 ปีที่แล้ว +1

    Its a treat to watch

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

    Thank you, Andrew! Great video!

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

      You're welcome Alexander, thanks for watching!

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

    Thank you for the sharing your experiences.

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

      Hi.
      iif(count=0,textbox1.value="Evet",textbox1.value="Hayır") I know that it is wrong. it is possible like this ?

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

      I got it. Thanks.

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

    thank you so much, Andrew.It helped me a lot

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

    Wow really learned lot. Thanks

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

      Happy to hear that, thank you for watching!

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

    I combine chr(13) And chr(10) in a variable, say nl and use that for my new line. Its short and that was the first way I learned about newline before I found vbnewline.

  • @HoangNguyen-pv6fz
    @HoangNguyen-pv6fz 11 หลายเดือนก่อน +1

    Thank you sir

    • @WiseOwlTutorials
      @WiseOwlTutorials  11 หลายเดือนก่อน

      You're welcome, thanks for watching!

  • @باليتركي
    @باليتركي 7 ปีที่แล้ว +1

    excellent work, thanks

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

    Informative

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

    thanks again for great content

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

    As always grea videos. Quick question, is there any particular reason you do not use the quick [A1] notation for ranges where applicable? Apart from not having intellisense.

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

    Thank you, Thank you, Thank you!!!

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

    Hi if i was using looking for text using wildcards and the quotation marks would i still need to use the code Lcase(r.value). For example if i am looking for the word Head Office why can i not just write If r.value Like "*Head Office*"

  • @ВячеславАнтонов-п3в
    @ВячеславАнтонов-п3в 7 ปีที่แล้ว

    Excuse for my English,it was very much would like to see SQL+WPF(real project with animations) - lessons. Thanks for your lessons, very good!++++++++

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

    Thanks

  • @rrrraaaacccc80
    @rrrraaaacccc80 วันที่ผ่านมา

    Great 💯👍

  • @adamt.j5815
    @adamt.j5815 7 ปีที่แล้ว

    Great video!
    I do have one question thou. How do you combine a variable (string) with a wildcard, is it possible?
    For example i would like to search a datasheet for specific words using variables. However the words in the datasheet are not exactly the same as the words stored in the variable . E.g Word in datasheet = Products, word in variable = Product. Resulting in
    (If "Target".value Like "Variable" Then) = No match, or (If "Target".value Like "Variable"* Then) = No joy either.
    Do you know any workaround?

    • @adamt.j5815
      @adamt.j5815 7 ปีที่แล้ว

      Thanks!
      I found a problem earlier in the code (the string was modified wrong) it now works as intended!

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

    Hello sir Andrew...I noticed in many of your videos that you have option in the VBE to comment out multiple lines of code .Is this something built in or are you using some add-in for that?

  • @HoangNguyen-pv6fz
    @HoangNguyen-pv6fz 11 หลายเดือนก่อน

    1:05:16 what if I don't know the length of the last word, sir? (Like, it can be 3, or 4, or 5 ...etc)

    • @WiseOwlTutorials
      @WiseOwlTutorials  11 หลายเดือนก่อน

      Hi! A simple option would be to replace the ???? with a single *
      I hope it helps!

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

    Hi
    Could you please help me how to use wild card characters for opening files

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

    Great tutorials! It would be usefull to add time markers to your videos everytime you start with a new topic.

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

      Something like this:
      The Sample Data: 1:28
      Returning Strings from Properties: 4:01
      Converting Values to Strings Implicitly: 5:30
      Converting Values to Strings Explicitly: 8:08
      And so on...

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

      Wouldn't it be possible to note the times when including the headline? It's great stuff anyway but it would make it even better :D

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

      I've personally been creating these myself; at the start of each segment, I pause the video, right click and select 'Copy video URL at current time' then paste in to Excel with a corresponding description.
      I've done this for nearly all the videos that Andrew has produced.
      In retrospect I wish I'd been also copying in to a third column the relevant operators that were introduced in each segment (e.g. 'like', 'vbNewLine', 'UCase' etc) so that if I wanted to brush up on the use of a particular one I could search for it within my Excel sheet. I've started doing that now.
      If you want I can share with you what I have so far

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

      That would be great!! :D I'm sure even Andrew would be happy about this Document. ^^

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

      Thanks for answering again and for spending your spare time! :)

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

    Does sting store and return the color value the of text?

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

      Hi! No, it doesn't. If you're referring to text in a cell in a worksheet you can use, for example, Range("A1").Font.Color to read or set the font colour.

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

    And to check if the folder exists based on date else create folder using VBA

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

    Fantastic video's, although I disagree with you on what makes a bad film. Really, moaning about Twilight but saying nothing about "Kingdom of Skulls", ah well takes all-sorts.

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

    the 4 dislikes are other u2bers that are jealous