VBAs/Macros for a beginner

[Ram_6833]

Hi All.

I am new to this forum so apologies for any mistakes/errors in advance.

I am not sure if this is the right section to post this but here it goes.

I have seen some people using VBAs and Macros in my previous workplace and I could sit there and watch them all day long. I am aware of the potential benefits of mastering them. If you already havent figured out I am new to VBAs/Macros and really want to learn them.

I would really appreciate if anyone could direct me in the right path/websites/links and/or learning metarials for a beginner.

Thanks in advance

[BanginMyHeadOnMyDesk]

You could try starting here : https://www.excel-easy.com/vba.html

But VBA is much easier to learn if you have a specific goal / project / problem to solve and break it down into small bits. Learn how to do each small bit (via asking questions on this forum perhaps?) and then learn how it all fits together.

Before you know if you'll be writing code without too much trouble.

Beth.

[AliGW]

Moved to The Water Cooler.

[Ram_6833]

Thank you Beth.

I was thinking of learning the fundementals then asking for advice on the project was my next step

[AliGW]

I think that's a good tactic, although don't be surprised if your first project takes a lot longer than expected! Make sure you allow at least three times as long as you expect.

[Ram_6833]

Hi Ali,

I am expecting it to take longer and aware that I need to invest lots of time into it so not expecting any miracles soon, plus already having read lots of threads here i also believe this forum may be the biggest help also

[PaulSP8]

I agree with Beth, you're better off getting a project you want to do and then learning how to do that, rather than trying to remember a load of stuff you might never need to know.

It's how I've learnt, and still do learn

You already know the most important part, what can be done - You just need to get on the road to knowing how to do it.

If you've no project in mind already but want to have a go then take a look at the Questions being asked on Forums like this and trying to come up with a soloution yourself.

It doesn't matter if you don't solve it, it doesn't matter how you approach the soloution - Just have a go at solving it and see how far you get

[CAntosh]

There is a thread on this forum with a host of suggested resources:

https://www.excelforum.com/excel-pro...materials.html

Personally, I started by reading a John Walkenbach book - might've been VBA for Dummies? - then started poking at my own projects from there.

[Ram_6833]

Thankyou Cantosh, Will give that thread ago

[Paul]

A little late to the party, but a good way to see examples of how various tasks can be done is to use the Macro Recorder. The code generated by the recorder is often not the most efficient, but if you have to do the same things repeatedly it works well. And of course, once you know the syntax and objects/methods/etc., you'll be able to modify the generated code to conform to variations.

For a look at a lot more details, you can use:

Getting Started: https://docs.microsoft.com/en-us/off...-vba-in-office

Excel Object model: https://docs.microsoft.com/en-us/off...l/object-model

Range object example: https://docs.microsoft.com/en-us/off....range(object)

[Olly]

Alternative viewpoint:

Devote your energies to learning Power Query / Power Pivot, instead of VBA.
Far more useful, far more transferable.