Related Posts
Bowl Leader
More Posts
New York City will never die
Community Builder
Chief
Which is the advanced mobile apart from iPhone?
Additional Posts in Excel Genius
Coach
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
I think a good start to creating macros is opening it up and use the recorder to record your clicks for a macro. It gives you an idea how to write the VBA for specific steps.
Good idea to get a sense of which objects you can access, but you can’t learn how to do loops / ifs etc that way.
You can literally create a macro that creates a pop up window with some text. Start really small with really mundane tasks like hiding a column or a row, etc. from there you will see how it all comes together. Microsoft documentation tells you how to do everything
As others have said, record a macro doing several basic tasks like type value in cell, copy to another, insert sheet, rename sheet, etc. Once you stop recording, go into the code (alt+F8 and select macro/edit or alt+f11 to open editor and double-click module). Examine the code created based on your actions to get a feel for it. You'll notice several actions that aren't necessary to get to the end result. Start to delete or edit pieces of the code and try to run it again.
It'll get you comfortable with editing and when you get to a point in the code you need something more elegant, just Google it. Learn how to edit someone's code for your purposes, test it separately, and then combine steps in one macro or create a macro to run each macro in the right order.
Best way to learn is through recording macros of what you want to do + piecing together repeatable, discrete chunks of code (Google, StackOverflow, etc)
For example, you may want to loop through all cells in a worksheet, or all worksheets in a workbook. Master those and everything becomes easier.
Thank you all for the suggestions- very helpful!