Vba

W

walkerdayle

I don't have a clue to using VBA. How do you begin to enter code t
perform tasks? Please Help

Anit
 
J

JulieD

Hi Anita

here's my 2cents worth ....
depends on how you learn -
if you're a "play around and see what happens" type of person then
record a couple of macros and look at the code generated
to record macros use tools / macro / record new macro ...
do some that sorts stuff
maybe a subtotal
maybe changes font
wouldn't do all in the same macro - it's easier to understand the code
if there's not too many lines
then to run the macros
choose tools / macro / macros & run
and to view the code
choose tools / macro / macros & edit

if you're a "give me the info step by step" type of person then
do a course (2 -3 day one - intro to programing with excel type thing)

if you're a book type person then
get hold of John Walkenbach's "Power Programming with Excel" (i think
that's the title)

Cheers
JulieD
 
Top