Problem solving in excel using it's advanced features is one thing, but learning to use VBA can be quite a scary thought if you are not a programmer. The great thing is, you don't need to be a programmer to start using visual basic for applications in excel. It can improve your overall productivity and motivation by automating manual and repetitive tasks. Here are some ways you can teach yourself.
1) Inbuilt Macro recorder - the best way to start your introduction to excel VBA is to start using the macro recorder for repetitive tasks. This could be as simple as adding your company information or calculating a column of data. The recorder is suited to simpler tasks. Any tasks that require looping or when the layout of the data on the worksheet changes, then the recorder will fall on its face. There are a number of problems with the macro recorder for advanced coding, but it helps at the start to get an idea of the syntax that is used and how things are done.
2) Books - Get an idiots guide or introductory book on the subject to help you with the recorder and how to use the VBA editor. There are books that will explain how to tidy up macro recorded code and how to make it faster. Programs developed with the macro recorder can be much slower.
3) Training - It is best to have a good grasp of the basics before you go on a course. If you don't, you might find it a challenge and will get less from it. The visual basic editor can provide a lot of examples of how code can be used. There is an inbuilt library to help. Press f1 on any keyword in the editor will bring up help on that word, which is very useful.
4) Online Help- You will find help on just about any aspect of excel online. I have always been able to find an answer to a question that has already been asked on the internet. Some websites are a bit more technical in their explanation. It does not need to be complicated - search for a less complicated answer.
Deixe o seu comentario
Post a Comment