Hi, Jen. You're not alone in learning VBA on your own. I have been doing
the same thing for the last year. But - if you *really* want to do it all
by yourself, with *NO* help at all, then you're really going to be in a
mess. Even a book or a free website is someone else's knowledge that is
helping you.
I suspect you mean "without going to a class" or paying for other
instruction. That's do-able - it's the way I've been learning. Here's how
I've done it:
(1) Figure out what you want to do, the open up the VBA editor (ALT + F11)
and try to make it happen.
(2) If you get stuck, press F1 and search the Help files.
(3) If no help there, do a Google search of the *excel* newsgroups. Odds
are good someone has asked the same question or a variation thereof before,
and there will be something to point you in the right direction. Here's an
add-in that I think makes this easier:
http://www.rondebruin.nl/Google.htm.
(4) Ask here on the Excel.Programming NG. People here are very helpful as
long as you're willing to learn.
HTH
Ed
"jen" wrote in message
...
Hi,
Can anyone recommend me a free website that I can learn
VBA in Excel? I know programming in Access, but I know
nothing in Excel, I wanted to learn VBA in Excel by my
own.
Thanks,
jen