Logic behind VBA code

[BarnBrian]

Can anyone explain to me the logical sequence in writing code. Maybe I'm stupid but I can't grasp the way to write the steps through code.

Help

 

[Jonmo1]

Ok, that's kinda like asking someone how to build a car. It's such a broad scope, so many different things to do.

A very good start for learning VBA is to use the Macro Recorder.

1. Think of a task you want to write some code for.
2. Figure out how to manually do that task by hand.
3. Start the Macro Recorder - tools - macro - record new macro
4. Do the Task Manually
5. Stop the macro recorder. - tools - macro - stop recording.
6. Look at and study the macro you just created.


Then ask specific questions in the Forum about how to improve parts of that code.

 

[ashish_gr3at]

Start creating some of macros with the above said method, and view their working --- by pressing Alt+f11

you will definitely get to know gradually about MACROS...
:D