Hi Experts,
I am beginning to learn VBA, FINALLY and need your guidance
I want to write some VBA scripts to understand the basics and able to write my helper functions but my main intention is put M and DAX in my learning program so that I can do data remediation etc.
I am struggling to get VB classes, Objects, Members in a list, MSDN is a great help but, either I am not seeing it well or that is how it works, but I want to know example: how to pass sheets name as input, I fail to get that in help
I see in the visual studio, Object Browser is lot more descriptive, but I am not able to see excel stuff there, can you guide me how best to see all the possible ways I can Input, use classes and members and it's properties I can utilize.
Thanks a ton in advance
I am beginning to learn VBA, FINALLY and need your guidance
I want to write some VBA scripts to understand the basics and able to write my helper functions but my main intention is put M and DAX in my learning program so that I can do data remediation etc.
I am struggling to get VB classes, Objects, Members in a list, MSDN is a great help but, either I am not seeing it well or that is how it works, but I want to know example: how to pass sheets name as input, I fail to get that in help
I see in the visual studio, Object Browser is lot more descriptive, but I am not able to see excel stuff there, can you guide me how best to see all the possible ways I can Input, use classes and members and it's properties I can utilize.
Thanks a ton in advance
