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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.