Excel VBA Introduction Part 53.1 - Working with Strings

[@frikduplessis8849]

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

[@WiseOwlTutorials]

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

[@shmred5705]

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

[@22Kyu]

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)

[@rrrraaaacccc80]

Great 💯👍

[@WiseOwlTutorials]

Thank you!

[@albertmartinez2701]

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]

Thanks for the comment and for watching, Albert!

[@setukansara]

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

[@krn14242]

I absolutely look forward to your videos.

[@sandorszilagyi5929]

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

[@donbogdala5428]

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!

[@nuhzakir8896]

Thank you for the sharing your experiences.

[@nuhzakir8896]

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

[@nuhzakir8896]

I got it. Thanks.

[@AmitSharma-po1zb]

Its a treat to watch

[@WiseOwlTutorials]

Thank you Amit!

[@kaistasch4028]

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

[@bigger302539]

That was a really fun video Thank you.

[@WiseOwlTutorials]

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

[@sashatv138]

Thank you, Andrew! Great video!

[@WiseOwlTutorials]

You're welcome Alexander, thanks for watching!

[@tajsay]

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

[@vijendran20]

Wow really learned lot. Thanks

[@WiseOwlTutorials]

Happy to hear that, thank you for watching!

[@HoangNguyen-pv6fz]

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]

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

[@باليتركي]

excellent work, thanks

[@drs10301]

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

[@HoangNguyen-pv6fz]

Thank you sir

[@WiseOwlTutorials]

You're welcome, thanks for watching!

[@Eltamoso]

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

[@WiseOwlTutorials]

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.

[@andrewhamilton7475]

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.

[@laurentiustefan398]

thanks again for great content

[@zawiszaskiresort]

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.

[@Globalpeaceseeker]

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*"

[@drs10301]

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

[@piytube1]

Informative

[@WiseOwlTutorials]

Thanks for watching!

[@imranbhatti8580]

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?

[@adamt.j5815]

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]

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

[@jicbs]

Thank you, Thank you, Thank you!!!

[@ВячеславАнтонов-п3в]

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]

Thanks

[@johanneslaidig9203]

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

[@johanneslaidig9203]

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]

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]

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]

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

[@johanneslaidig9203]

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

[@alexchapman3924]

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]

the 4 dislikes are other u2bers that are jealous