Learn Excel macro programming

[Ravi]

Hi,

I'm a fairly new user for excel and i want to learn how to write macros in
excel. Is there a website that can help me with this ? I would prefer to
know if any video tutorials for the same are available for a free download

 

[Niek Otten]

Look here±

http://www.datapigtechnologies.com/flashfiles/recordmacros.html

 

[JLGWhiz]

Here are a few sites that provide sample code to do almost anything you would
need to do to manipulate data in an excel worksheet. However, I would
recommend that you also get a book that explains the basics of VBA about
Objects, Variables, Properties, Data Types, Keywords, etc. You can write a
lot of code by using examples, but if you don't understand why it does what
it does, then you really are not making much progress and will always be
wondering why you get those error messages.

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeexcelhowto.htm

http://www.cpearson.com/excel/topic.aspx

http://www.rondebruin.nl/tips.htm

 

[Happy Trails]

Here are a few sites that provide sample code to do almost anything you would
need to do to manipulate data in an excel worksheet. However, I would
recommend that you also get a book that explains the basics of VBA about
Objects, Variables, Properties, Data Types, Keywords, etc. You can write a
lot of code by using examples, but if you don't understand why it does what
it does, then you really are not making much progress and will always be
wondering why you get those error messages.

http://www.kayodeok.btinternet.co.uk/favorites/kbofficeexcelhowto.htm

http://www.cpearson.com/excel/topic.aspx

http://www.rondebruin.nl/tips.htm

Another good place to start, for xl (and access and word and ppt etc)
is here:

http://www.msofficehelp.net/

It will give you many links to many other sites, and one very good one
is here:

http://www.erlandsendata.no/english/

 

[Rick Rothstein]

Here are a few more for you to look at...

http://www.bettersolutions.com/excel/ECC653/YR646543531.htm

http://www.anthony-vba.kefra.com/

http://www.tushar-mehta.com/excel/vba/beyond_the_macro_recorder/index.htm