PDA

View Full Version : How to Make Handwritten Code or Macros



hardeep
04-01-2010, 08:48 PM
H! Experts

I am Totally Stupid In codes and Macros, I Know how to Record and Use the Macros.

But, i want to make Handwritten macro.:banghead:

Could anybody help me and tell me the Site which show Step by Step

Or any book in Market which Really Help Me:help

Thanks in Advance

Hardeep kanwar

stanleydgrom
04-01-2010, 08:52 PM
hardeep,

Try:

Training / Books / Sites:

How to Learn to Write Macros
http://articles.excelyogi.com/playin...ba/2008/10/27/

How to use the macro recorder
http://articles.excelyogi.com/

Click here and scroll down to Getting Started with VBA.
http://www.datapigtechnologies.com/ExcelMain.htm

If you are serious about learning VBA try
http://www.add-ins.com/vbhelp.htm

Excel Tutorials and Tips - VBA - macros - training
http://www.mrexcel.com/articles.shtml

See David McRitchie's site if you just started with VBA
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Debra Dalgleish has some notes how to implement macros here:
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

http://www.excel-vba.com/

http://www.mvps.org/dmcritchie/excel/getstarted.htm

http://www.exceltip.com/excel_links.html

(livelessons video)
Excel VBA and Macros with MrExcel
ISBN: 0-7897-3938-0
http://www.amazon.com/Excel-Macros-M...7936479&sr=1-1

http://www.xl-central.com/index.html

http://www.datapigtechnologies.com/ExcelMain.htm

Dependent validation lists. Debra has a neat little tutorial here.
http://www.contextures.com/xlDataVal02.html

Cascading queries
http://www.tushar-mehta.com/excel/ne...ing_dropdowns/
http://www.contextures.com/xlDataVal05.html

Programming The VBA Editor - Created by Chip Pearson at Pearson Software Consulting LLC
This page describes how to write code that modifies or reads other VBA code.
http://www.cpearson.com/Excel/vbe.aspx

Locating files containing VBA
Searching Files in Subfolders for VBA code string:
http://www.dailydoseofexcel.com/arch...a-code-string/
http://www.pcreview.co.uk/forums/thread-978054.php

Excel 2003 Power Programming with VBA, by John Walkenbach

VBA and Macros for Microsoft Excel, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel Hacks 100 Industrial-Strength Tips & Tools, by David & Traina Hawley

VBA and Macros for Microsoft Excel 2007, by Bill Jelen "Mr.Excel" and Tracy Syrstad

Excel 2007 Book: you can try this...there is a try before you buy ebook available at this link…
http://www.mrexcel.com/learnexcel2.shtml

DonkeyOte: My Recommended Reading:
Volatility
http://www.decisionmodels.com/calcsecretsi.htm

Sumproduct
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Arrays
http://www.xtremevbtalk.com/showthread.php?t=296012

Pivot Intro
http://peltiertech.com/Excel/Pivots/pivotstart.htm

Email from XL - VBA
http://www.rondebruin.nl/sendmail.htm

Outlook VBA
http://www.outlookcode.com/article.aspx?ID=40

Function Dictionary
http://www.xlfdic.com/

Function Translations
http://www.piuha.fi/excel-function-name-translation/

Dynamic Named Ranges
http://www.contextures.com/xlNames01.html

And, as your skills increase, try answering posts on sites like:
http://www.mrexcel.com/
http://www.excelforum.com/
http://www.ozgrid.com/
http://www.vbaexpress.com/portal.php
http://p2p.wrox.com/excel-vba-79/


Have a great day,
Stan

Mis_Sailesh
04-02-2010, 01:06 AM
Hi Hardeep,

Just think of small jobs and read about them one by one to start with, internet is a good place to get help around :-
like displaying a message-use MsgBox
getting input - use InputBox
displaying today's date - use vba.date()
read about User Defined Functions(UDF)
read about Loop - for loop is easiest to learn
read about logical checks - if is the most frequently used one
read codes available on google and try understanding them

This way you can directly jump into the VBA world...

Welcome onboard...
:help

Mis_Sailesh
04-02-2010, 01:27 AM
Hi Hardeep,

Please revert to me if you require more help...

hardeep
04-02-2010, 01:52 AM
Thnxs stanleydgrom for the Links

Mis_Sailesh Thanks for the Gr8 Support

Definitely, I revert back if Facing Problems

Thanks:beerchug:

Hardeep kanwar

Mis_Sailesh
04-02-2010, 02:12 AM
You Know Hardeep,

You only required "Will" to learn VBA, its really very simple and powerful...
Just keep exploring, don't give up ....

:help