what are some important tips for a beginner in MACRO/VBA?

[weemaster]

I just started using VBA. would like some tips and tricks.
Thanks.

 

[Logit]

Properly INDENT your code ... all of it.

When it comes time to ask for assistance - and those times will occur - have properly indented code will assist others in assisting you.

 

[dmt32]

I just started using VBA. would like some tips and tricks.
Thanks.

Hi,
welcome to forum.
Plenty of free online guides like this one: what are some important tips for a beginner in MACRO/VBA?
that lists best practices which you may find helpful but there are others.

Also, make good use of the VBA helpfile

Dave

 

[Fluff]

@dmt32
I think you added the wrong link, that points to this thread.

 

[GWteB]

@weemaster,
You could perhaps start with reading this brief article ...

Short Guide to Better VBA

Following are some guidelines to improve your VBA skills and macro writing. Writing macros in Excel uses Visual Basic for Applications (VBA) and so in a way you are programming. As with nearly all programming languages this means you have to use a logical approach and be accurate. VBA has a...

www.mrexcel.com

 

[dmt32]

@dmt32
I think you added the wrong link, that points to this thread.

thanks - distracted with grandchildren is my excuse!

 

[dmt32]

try again

link you may find helpful:excel-vba - Getting started with excel-vba | excel-vba Tutorial

Dave

 

[Fluff]

distracted with grandchildren

An excellent reason.

 

[Eric W]

Another good article:

The Next Step Beyond the Macro Recorder in VBA Programming | | InformIT

Don’t rely solely on the macro recorder to teach you VBA programming; it’s meant only as an introduction, and you can’t rely on it for more advanced programming methods. Tracy Syrstad, co-author of <a...

www.informit.com

 

[cooper645]

I used that book. Great place to start. Still have it on my desk.

run code on a copy of your workbook/sheet or even a test one.

enjoy it and save little snippets that you will find useful as notes or macros in the personal workbook.

have fun!!!