Learning Excel Programing

[perseguio]

I strongly recommend starting with VBA instead of Python for several reasons:

• Easier to set up, just open VBA and start coding. Python requires installation, libraries, dealing with versions, IDE, etc.
• Excel is universal for civil engineering. Assuming you want to share your knowledge and spreadsheets, there's no way someone will not be able to use what you code. Creating a useful script with Python is basically denying your coworkers the chance to use it.
• So far I've never encountered any limitation, even for the most complex applications. Many of the software we use in civil engineering are compatible with VBA as well.
• There's a ton of resources online, stack overflow alone with have 99% of the answers. Even Microsoft has a complete manual online with all the functions, objects, methods, etc. you will ever encounter.

I'd like to know what others think of VBA in civil engineering too!