Browse 554 attributed reviews, viewable separately for our classroom and online training

Details for DBlakeMAAT

DBlakeMAAT has participated in the following threads:

Added by DBlakeMAAT on 18 Aug 2019 at 14:33

Hi Andrew

Love the way you teach and the videos, they are always my go to point and have allowed me to do some great things!

My question is on using User Defined Type Declarations with class modules (specifically property statements), I have a large number of private fields in my class module (SupplierASearchString, SupplierAWorksheet, SupplierBSearchString, SupplierBWorkSheet etc etc). I am thinking of trying to simplify this by using User Defined Types (UDT), thus allowing me to have a single Private Field per supplier declared using my UDT.

It would appear that you can not declare property statements for the individual elements of a UDT.  Not all of my elements are set at the same moment in the procedures that i am running, would this mean that UDT are probably not the best approach or am i missing something fundimental with regards to UDTs? 

 

Many thanks 

 

Dave Blake MAAT

Added by DBlakeMAAT on 24 Sep 2019 at 16:47

Thanks for the mention. It is also important to note that whilst you have stated the 4th argument (match_mode) is required (exact match, approx match and others too), exact match is now the default argument (finally), this differs from VLOOKUP where the default is approximate match. Therefore if the argument is omitted you will get an exact match. 

Regards

Dave Blake MAAT

Added by DBlakeMAAT on 13 Oct 2020 at 13:32

i would have voted for Python too, unfortunatly i appear to have missed the poll!

I have a specific project coming up where i need to retreive a JSON from an online service and extract specific information and then output to a user friendly GUI using Tkinter.  This is a project that was the reason that i started to look at Python earlier this year, but then COVID hit and the project was put on hold, but hoping to restart at some point.

Other possibilities for using Python is anything data sciences driven, such as neural networks using the TensorFlow and Keras libraries.

If you really wanted to you could see if you can re-create Flappy Owl using the Tutle Graphics library! ;)