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)
@@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 !
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.
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.
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.
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*"
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?
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?
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...
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
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.
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.
Thank you Andrew this is a awesome tutorial I don't know how on earth I missed this one,
Thanks so much Frik, happy to hear that you enjoyed it!
Becoming good at vba AND random movie information. Great job!
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)
Looking forward to see the next video 53.2... Thank you.
I absolutely look forward to your videos.
@@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 !
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.
Thanks for the comment and for watching, Albert!
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!
Thanks a lot. This definetly helps me to optimize some of my older procedures. Great tutorial!!!
That was a really fun video
Thank you.
Glad you enjoyed it, thanks for taking the time to comment!
Its a treat to watch
Thank you Amit!
Thank you, Andrew! Great video!
You're welcome Alexander, thanks for watching!
Thank you for the sharing your experiences.
Hi.
iif(count=0,textbox1.value="Evet",textbox1.value="Hayır") I know that it is wrong. it is possible like this ?
I got it. Thanks.
thank you so much, Andrew.It helped me a lot
Wow really learned lot. Thanks
Happy to hear that, thank you for watching!
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.
Thank you sir
You're welcome, thanks for watching!
excellent work, thanks
Informative
Thanks for watching!
thanks again for great content
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.
Thank you, Thank you, Thank you!!!
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*"
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!++++++++
Thanks
Great 💯👍
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?
Thanks!
I found a problem earlier in the code (the string was modified wrong) it now works as intended!
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?
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)
Hi! A simple option would be to replace the ???? with a single *
I hope it helps!
Hi
Could you please help me how to use wild card characters for opening files
Great tutorials! It would be usefull to add time markers to your videos everytime you start with a new topic.
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...
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
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
That would be great!! :D I'm sure even Andrew would be happy about this Document. ^^
Thanks for answering again and for spending your spare time! :)
Does sting store and return the color value the of text?
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.
And to check if the folder exists based on date else create folder using VBA
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.
the 4 dislikes are other u2bers that are jealous