Forum Discussion
aes35
Jul 16, 2019Copper Contributor
Complex VBA Excel - Best Practice (KISS)- Visual Diagrams-Wireframes or Recommendations
Frustrated quickly when getting 40 lines of VBA down to learn it can be written In 2 lines going a different route. Recommendations for the best practices on CLEANIEST way possible for Excel VBA ...
Jul 16, 2019
aes35 What is your question?
aes35
Jul 16, 2019Copper Contributor
1. I was asking for references visual learning aids for some aspects of the VBA (Objects)
2. Is there any recommended method or order to adding: If you have multiple Date and/or CboBox options for individuals to select data to populate Excel VBA worksheet coming from variety of data sources leveraging VBA functions, actions, etc.
functions, forms and/or modules...
Functions within functions within functions
Ifs within Ifs with in Ifs
Or is this basically what your preference is.... I am trying to identify issues that could cause the code to CRAWL thru some looping and functions crossing active workbooks.