-
How to Make Handwritten Code or Macros
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.
Could anybody help me and tell me the Site which show Step by Step
Or any book in Market which Really Help Me
Thanks in Advance
Hardeep kanwar
-
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
-
Think...
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...
Sailesh Kr Mishra
Proud To Be An Indian
-
Need Help?
Hi Hardeep,
Please revert to me if you require more help...
Sailesh Kr Mishra
Proud To Be An Indian
-
Thnxs stanleydgrom for the Links
Mis_Sailesh Thanks for the Gr8 Support
Definitely, I revert back if Facing Problems
Thanks
Hardeep kanwar
-
You Know...
You Know Hardeep,
You only required "Will" to learn VBA, its really very simple and powerful...
Just keep exploring, don't give up ....
Sailesh Kr Mishra
Proud To Be An Indian
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules