Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning VBA online for Excel
I wish all the members a happy and prosperous new year I am 54 years. Started working on computers since 1990 or so startin with Word Star and Lotus. Switched over to MS Office from 199 converting or using Lotus files from Excel. Now I am extensively usin Excel for all my office work Salaries, Income Tax, Provident Fund Monthly and Annual Accounting. I am better in using all the Menus an take their benefits including use of functions. I am able to recor simple macros for the repetitive tasks, assign them to self-create tool bar, menus, sub-menus (controls) and key board letters with Ctrl+ keys but cannot write macros myself as I do not have the knowledge o VB. I want to learn more abouot VB and programming in Excel. Can learn on-line easy-way without academically learning through big books Please suggest easy way to learn VB and preparing macros which woul easy my office work and I can put all my work in a programme/softwar style. Thanks Gandh -- gandhi318Posted from - http://www.officehelp.i |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning VBA online for Excel
Hi Gandhi,
You may wish to visit David McRitchie's 'Getting Started With Macros And User Defined Functions' at: http://www.mvps.org/dmcritchie/excel/getstarted.htm You might also look at David's tutorials page at: http://www.mvps.org/dmcritchie/excel....htm#tutorials The VBA material is towards the end of that section. --- Regards, Norman "gandhi318" wrote in message ... I wish all the members a happy and prosperous new year I am 54 years. Started working on computers since 1990 or so starting with Word Star and Lotus. Switched over to MS Office from 1997 converting or using Lotus files from Excel. Now I am extensively using Excel for all my office work Salaries, Income Tax, Provident Fund, Monthly and Annual Accounting. I am better in using all the Menus and take their benefits including use of functions. I am able to record simple macros for the repetitive tasks, assign them to self-created tool bar, menus, sub-menus (controls) and key board letters with Ctrl+ keys but cannot write macros myself as I do not have the knowledge of VB. I want to learn more abouot VB and programming in Excel. Can I learn on-line easy-way without academically learning through big books. Please suggest easy way to learn VB and preparing macros which would easy my office work and I can put all my work in a programme/software style. Thanks Gandhi -- gandhi318Posted from - http://www.officehelp.in |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning VBA online for Excel
gandhi318 wrote: I wish all the members a happy and prosperous new year I am 54 years. Started working on computers since 1990 or so starting with Word Star and Lotus. Switched over to MS Office from 1997 converting or using Lotus files from Excel. Now I am extensively using Excel for all my office work Salaries, Income Tax, Provident Fund, Monthly and Annual Accounting. I am better in using all the Menus and take their benefits including use of functions. I am able to record simple macros for the repetitive tasks, assign them to self-created tool bar, menus, sub-menus (controls) and key board letters with Ctrl+ keys but cannot write macros myself as I do not have the knowledge of VB. I want to learn more abouot VB and programming in Excel. Can I learn on-line easy-way without academically learning through big books. Please suggest easy way to learn VB and preparing macros which would easy my office work and I can put all my work in a programme/software style. Thanks Gandhi -- gandhi318Posted from - http://www.officehelp.in My age and experience closely parallels your own, except that I am so lazy that I *had* to learn VBA in order to save steps later. I suppose it's a toss-up whether the time I've spent learning VBA has actually saved any time or steps in my processing but ... I do know some VBA now. The way I learned was to record simple macros, as you have done, and then read them (Alt-F11) to see how they worked. (I had the added benefit of having worked with simple Lotus 1-2-3 keyboard macros, so I knew some of the things that I wanted to do in Excel.) My first step was to find out how to make things interactive. As you know, the macros you record are explicitly literal, having worksheets named exactly what they were when recorded, operating on exactly the same ranges, etc. So I wanted them to operate over different workbooks, different sheets (or all sheets) and different ranges. Then I had to learn the various Looping constructs For ... Next; Do While; Do (until), etc. Conditional programming with If / Then / ElseIf / End If ... and you'll be off and running before you know it. More often than not I will still "record" a macro to do a bit of complex processing, and then use VBA to fine tune it (the code is pretty boggy "as recorded"), add looping, conditions, user inputs, error traps, etc. And comments. Don't forget to add comments! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning VBA online for Excel
One book I'd highly recommend for your situation is "Excel VBA in Easy
Steps". It's easy to read, and will get you to the point where you can usefully progress using Help and this newsgroup. -- Gordon Rainsford London UK gandhi318 wrote: I wish all the members a happy and prosperous new year I am 54 years. Started working on computers since 1990 or so startingwith Word Star and Lotus. Switched over to MS Office from 1997converting or using Lotus files from Excel. Now I am extensively usingExcel for all my office work Salaries, Income Tax, Provident Fund,Monthly and Annual Accounting. I am better in using all the Menus andtake their benefits including use of functions. I am able to recordsimple macros for the repetitive tasks, assign them to self-createdtool bar, menus, sub-menus (controls) and key board letters with Ctrl+ keys but cannot write macros myself as I do not have the knowledge ofVB. I want to learn more abouot VB and programming in Excel. Can Ilearn on-line easy-way without academically learning through big books.Please suggest easy way to learn VB and preparing macros which wouldeasy my office work and I can put all my work in a programme/softwarestyle. Thanks Gandhi-- gandhi318Posted from - http://www.officehelp.in |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning VBA online for Excel
Many thanks to Mr. Norman Jones, Mr. Blue Hornet and Mr. Gordo Rainsford for their valuable suggestions. I hope by going throug those links and books, I would definately improve my little knowledg of progrramming in Excel which should help my Institute and all siste Institutions. Thanks you again, Gandh -- gandhi318Posted from - http://www.officehelp.i |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning VBA online for Excel
Dear Gordon Rainsford, Where do I get that book. Whether an Indian Edition is available. Wh is the Author and Publisher. Please do provide details. Thanks Gandhi Gordon Rainsford Wrote: One book I'd highly recommend for your situation is "Excel VBA in Easy Steps". It's easy to read, and will get you to the point where you can usefully progress using Help and this newsgroup. -- Gordon Rainsford London UK gandhi318 wrote: I wish all the members a happy and prosperous new year I am 54 years. Started working on computers since 1990 or s startingwith Word Star and Lotus. Switched over to MS Office from 1997convertin or using Lotus files from Excel. Now I am extensively usingExcel for all my office work Salaries, Income Tax, Provident Fund,Monthly and Annual Accounting. I am better in using all the Menus andtake their benefits including use of functions. I am able to recordsimple macros for the repetitive tasks, assign them to self-createdtool bar, menus sub-menus (controls) and key board letters with Ctrl+ keys but cannot writ macros myself as I do not have the knowledge ofVB. I want to learn mor abouot VB and programming in Excel. Can Ilearn on-line easy-way without academically learning through big books.Please suggest easy way t learn VB and preparing macros which wouldeasy my office work and I can pu all my work in a programme/softwarestyle. Thanks Gandhi-- gandhi318Posted from - http://www.officehelp.i -- gandhi318Posted from - http://www.officehelp.i |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Learning VBA online for Excel
Excel Vba in Easy Steps (Paperback)
by Ed Robinson Publisher: Computer Step (May 31, 2004) ISBN: 1840782714 available from amazon -- Gordon Rainsford London UK gandhi318 wrote: Dear Gordon Rainsford, Where do I get that book. Whether an Indian Edition is available. Whois the Author and Publisher. Please do provide details. Thanks Gandhi Gordon Rainsford Wrote: One book I'd highly recommend for your situation is "Excel VBA in Easy Steps". It's easy to read, and will get you to the point where you can usefully progress using Help and this newsgroup. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
GET PAID $2000 PER WEEK FROM ONLINE MONEY MAKING PROGRAMME.THEREALPROGRAMME IN ONLINE | Excel Worksheet Functions | |||
Learning excel | Charts and Charting in Excel | |||
CDs and learning excel | Charts and Charting in Excel | |||
Learning Excel | Excel Programming | |||
Learning how to use Excel | Excel Discussion (Misc queries) |