Brilliant tutorial Andrew, your last example which took half of the video blow my mind indeed. In the beginning, I was only interested in switch function as was getting acquainted with it, but your example creating sheets and adding array names to them was a master piece, and made me watch and follow along with the tutorial. It took me little bit time to to get behind the logic in some pieces of code but I contrived in it. Thank you sharing all that knowledge with us. 👍
Hi Andrew, just finished watching the Iif function video and this one and let me tell you: I've always took for granted these couple of useful little functions. Thanks so much for the insight, I'll use these little friends more often. The following tip is for the users, in case they get a runtime error. There's a little hiccup with the Range("A2", range("A1").end(xldown)) function; I've always ran into a runtime error when I used it in a function, the VLookup function would be one of those examples. Always wanted me to have that worksheet active. Instead of that, what I do is create a variable that holds the last row, something like lrow=Sheet1.Range("A" & rows.count).end(xlup).row (if I want to start my range selection from a specific row, and data is not present, I would either sum lrow or just do a quick if lrow=2 then lrow=3, and this will ensure you don't affect your headers when you don't have data) Then, on the actual range of cells I would go for something like: Sheet1.Range("A3:L" & lrow).select for example. And the best thing is that you don't have to have that sheet active to work . Hope you found the little tip useful. :) Thanks man!
I recently stumbled across WiseOwl Training videos on TH-cam and they are wonderful especially VBA!. I was looking specifically for how to create a 9-grid in excel for succession planning. Where can I find how to make one or the specific lessons to pull together to create. I am making my way through the courses but wanted to know if you all have what I am looking for. I welcome any suggestions or advise that you may have. Best Regards
Bonjour bravo encore pour vos vidéos. Une question qui n'a rien à voir avec cette vidéo: quel est l'inconvénient d'enregistrer un fichier Excel sous format XLB.Merci
Mr. WiseOwl, I am trying to develop and application which shall collect all output results from an analysis software and process it for my further processing. I already made three macro-powered workbooks, which are working independently (and contain data of beams, columns and foundations separately). Now I am making a comprehensive application which call all these workbooks time to time as per requirement and make a final schedule of each item. The problem, I am facing now is, that the worksheets to be opened contain macros, and need approval of user because of his settings. Can I open these worksheets with some command or I have to shift the code of these worksheets in to my new application and make them macro-free and then open?
Hi Andrew, Hey one thing I'm personally struggling with at the moment is the Object Browser in VBA. I'm trying to interact with other programs that don't have much if any supporting documentation on the syntax needed to do achieve what I'm looking for. There also seems to be a lack of cogent videos on this on TH-cam. Would you consider doing a dedicated tutorial on this at some point? Cheers! Dan
Yeah ok cheers. I looked in to it a little and I think you're right; the object browser doesn't appear to give enough info to reverse-engineer syntax. But a video on the object browser would probably still be generally helpful to the community though, as like I say it seems to be only minimally covered by others. The analysis software I'm working with is called Larsa 4D - it's a specialized structural finite element software for bridge analysis. The tech support is responsive to queries about how to achieve specific things with it in VBA, but obviously it's not ideal having to repeatedly email back and forth during development - would be nice to just have a full manual and run with it. Anyway, I appreciate the response. Keep up the good work :)
amazing video as always, could you please make a tutorial on Progress Bar display when running a code? please make few examples of different codes in it !
Thank you, I have just made donation, you should consider making all your course (as on your website) online as well, so people around the globe can make benefit from it
This topics looks hard to me, because some of the terms don't know. Such as ByVal, ByRef,array. Please give me a link for those term or after giving lecture on those term put this video next. That will be more understandable. Overall this is good video tutorial.
![“อ.เบียร์ คนตื่นธรรม” มาตามคำเรียกร้อง แหกศาสตร์ฮวงจุ้ย เตือนสติอย่างมงาย | แฉ 7 พ.ย. 67 [1/3]](http://i.ytimg.com/vi/5fc4S3xBNfc/mqdefault.jpg)
![[UNCUT] The Loyal Pin ปิ่นภักดิ์ EP.15 (2/4)](http://i.ytimg.com/vi/qbHbshrA1f0/mqdefault.jpg)
![[Full] 4 ต่อ 4 Celebrity EP.922 | 10 พ.ย. 67 | one31](http://i.ytimg.com/vi/zmV5HRIxIBI/mqdefault.jpg)
This video is a gold mine. I came for switch statements and have left with powerful knowledge! It feels like going to grandma's house one Christmas.
Brilliant tutorial Andrew, your last example which took half of the video blow my mind indeed. In the beginning, I was only interested in switch function as was getting acquainted with it, but your example creating sheets and adding array names to them was a master piece, and made me watch and follow along with the tutorial. It took me little bit time to to get behind the logic in some pieces of code but I contrived in it. Thank you sharing all that knowledge with us. 👍
Thank you Denin! Happy to hear that you enjoyed that one and persevered to work through the difficult parts! Thanks for watching!
Hi Andrew, just finished watching the Iif function video and this one and let me tell you: I've always took for granted these couple of useful little functions. Thanks so much for the insight, I'll use these little friends more often.
The following tip is for the users, in case they get a runtime error.
There's a little hiccup with the Range("A2", range("A1").end(xldown)) function; I've always ran into a runtime error when I used it in a function, the VLookup function would be one of those examples. Always wanted me to have that worksheet active.
Instead of that, what I do is create a variable that holds the last row, something like lrow=Sheet1.Range("A" & rows.count).end(xlup).row (if I want to start my range selection from a specific row, and data is not present, I would either sum lrow or just do a quick if lrow=2 then lrow=3, and this will ensure you don't affect your headers when you don't have data)
Then, on the actual range of cells I would go for something like:
Sheet1.Range("A3:L" & lrow).select for example. And the best thing is that you don't have to have that sheet active to work .
Hope you found the little tip useful. :)
Thanks man!
Very very useful sir...plzz keep doing it.
Thanks Andrew.
Great video! Thanks!
I recently stumbled across WiseOwl Training videos on TH-cam and they are wonderful especially VBA!. I was looking specifically for how to create a 9-grid in excel for succession planning. Where can I find how to make one or the specific lessons to pull together to create. I am making my way through the courses but wanted to know if you all have what I am looking for. I welcome any suggestions or advise that you may have. Best Regards
Bonjour bravo encore pour vos vidéos. Une question qui n'a rien à voir avec cette vidéo: quel est l'inconvénient d'enregistrer un fichier Excel sous format XLB.Merci
Mr. WiseOwl, I am trying to develop and application which shall collect all output results from an analysis software and process it for my further processing. I already made three macro-powered workbooks, which are working independently (and contain data of beams, columns and foundations separately). Now I am making a comprehensive application which call all these workbooks time to time as per requirement and make a final schedule of each item. The problem, I am facing now is, that the worksheets to be opened contain macros, and need approval of user because of his settings. Can I open these worksheets with some command or I have to shift the code of these worksheets in to my new application and make them macro-free and then open?
Hi Andrew,
Hey one thing I'm personally struggling with at the moment is the Object Browser in VBA. I'm trying to interact with other programs that don't have much if any supporting documentation on the syntax needed to do achieve what I'm looking for. There also seems to be a lack of cogent videos on this on TH-cam. Would you consider doing a dedicated tutorial on this at some point?
Cheers!
Dan
Yeah ok cheers. I looked in to it a little and I think you're right; the object browser doesn't appear to give enough info to reverse-engineer syntax.
But a video on the object browser would probably still be generally helpful to the community though, as like I say it seems to be only minimally covered by others.
The analysis software I'm working with is called Larsa 4D - it's a specialized structural finite element software for bridge analysis. The tech support is responsive to queries about how to achieve specific things with it in VBA, but obviously it's not ideal having to repeatedly email back and forth during development - would be nice to just have a full manual and run with it.
Anyway, I appreciate the response. Keep up the good work :)
May u upload the access video (all tutorial)
amazing video as always, could you please make a tutorial on Progress Bar display when running a code? please make few examples of different codes in it !
Thank you, I have just made donation, you should consider making all your course (as on your website) online as well, so people around the globe can make benefit from it
This topics looks hard to me, because some of the terms don't know. Such as ByVal, ByRef,array. Please give me a link for those term or after giving lecture on those term put this video next. That will be more understandable. Overall this is good video tutorial.