awesomethanksVenkat From: Venkat CV <venkat1....@gmail.com> To: excel-macros@googlegroups.com Sent: Tue, 26 July, 2011 12:16:54 PM Subject: Re: $$Excel-Macros$$ Lesson 1: The Visual Basic Editor in Excel (VBE)
Hi Harsh, Try the Below link for All lessons and continuation of Below.. http://www.excel-vba.com/excel-vba-contents.htm Best Regards, Venkat Chennai On Tue, Jul 26, 2011 at 10:07 AM, harsh shah <harshsha...@gmail.com> wrote: awaiting more lessons.... > > > >On 26 July 2011 09:24, XLS S <xlst...@gmail.com> wrote: > >Lesson 1: The Visual Basic Editor in Excel (VBE) >> >>For users of Excel 1997 to 2006: The first thing that you need to do is to >>make >>sure that the security level of Excel is set at either "Low" or "Medium" so >>that >>you can use the macros (VBA procedures) that you develop. From the menu bar >>of >>Excel select "Tools" then "Macro" then "Security" and select "Medium". >>For users of Excel 2007 to 2010: From the "Developer" ribbon click on the >>"Macro >>Security" button. Check the second level "Disable all Macros with >>Notification" >>and you are set. >>Setting up the Visual Basic Editor in Excel (VBE) >>The Visual Basic Editor is a program within Excel that allows you to >>communicate >>with Excel. We will open it and start by setting it up so that working within >>it >>becomes easy and efficient. >>Print this page, open Excel and open a new workbook (Book1). >>On your keyboard press the "ALT" key (left of the space bar) and hold, strike >>the "F11"key (the F11 key is at the top of your keyboard).You now see the >>Visual >>Basic Editor. Again press "ALT/F11" and you are back into Excel. Use the >>"ALT/F11" key to go from Excel to the VBA and back. >>When you first open the VBE you will see is a window somewhat like the image >>below. >>If there are any open windows within the VBE like in the image below click on >>the Xs to close them and see a gray rectangle filling up the bottom part of >>the >>screen like in the image above. >>The Three Windows in the Visual Basic Editor >>To be efficient when working with the VBE there should always be 3 windows >>showing like in the image below; the Project Window (1), the Code Window ( >>2), and the Properties Window (3), arranged as in the image below. You >>can resize the windows by left-clicking where the red stars are, holding and >>moving sideways or up and down. We will study each of the three windows in >>lessons 2, 3 and 4 but first we will set them up in the VBE. >>In the exercise below we will setup the 3 windows of the VBE. >>Exercise 1 (Create your first macro and use it) >>Remember that you will perform this task only once as each time you will open >>the VBE it will remain setup. >> >>Step 1: Close all the windows that are open in the VBE to end up with this: >>Step 2: Go to the menu bar "View" and click "Project Explorer". The result >>will >>be somewhat like the image below: >>If the project window already appears as a column on the left side of the >>screen >>there is nothing else that you have to do for now. If the project window >>appears >>in the middle of the gray area like above, right-click in the white space in >>the >>middle of the project window and check "Dockable". Then click on the top blue >>bar of the Project window, hold and drag it left until the cursor (white >>arrow) >>touches the middle of the left side of the screen. When you let go of the >>mouse >>button the end result should be like shown in the image below. >>Congratulations >>you have setup the first major window of the VBE. >>Step 3: Move your cursor on the line separating the project window and the >>gray >>rectangle. When it turns to two small parallel lines and arrows click, hold >>and >>move the lines sideways. Resize the two windows as you want them. >>Step 4: Go back to the menu bar "View" and click "Properties Window". The >>Properties window will appear somewhat like in the image below. >>If the Properties window is already located below the Project window there is >>nothing left to do. If it shows like in the image above, right-click in the >>white space in the middle of the Properties window and check "Dockable". Then >>click on the top blue bar of the Properties window and drag it left and >>down until the cursor (white arrow) touches the center of the bottom of the >>Project window. When you let go of the mouse button the end result should be >>as >>the image below. Congratulations you have setup the second major window of >>the >>VBE. >>Step 5: Move your cursor on the line separating the project window and the >>properties window. When it turns to two small parallel lines and arrows >>click, >>hold and move the lines vertically. Resize the two windows as you want them. >>Step 6: To add the code window to the setup, you just have to double click on >>the name of a component in the Project window (Sheet1, Sheet2, Sheet3 or >>ThisWorkbook) and its code window appears within the gray rectangle. You >>can maximize any Code window by clicking on its "Maximize" button . >> >>The final result looks like the image below. The words "Option Explicit" >>might >>not be present in your Code window. We will address this issue later in the >>lesson on variables (Lesson 19). You might also have a VBAProject named >>FUNCRES.XLA or FUNCRES.XLAM in the project window. Forget about this project >>for >>now. >>Step 6: Now go to Excel and close it. Re-open Excel, go to the VBE (ALT/F11) >>and >>you will see that the VBE setup persists. Congratulations, you are now ready >>to >>work in the Visual Basic Editor. >>We will discover more about each of these three windows in lessons 2 (Project >>Window), 3 (Properties Window) and 4 (Code Windows). >>Remember that you can use "ALT/F11" to navigate from Excel to the VBE and back. >>Close the VBE and close Excel without saving anything.-- >>---------------------------------------------------------------------------------- >> >>Some important links for excel users: >>1. Follow us on TWITTER for tips tricks and links : >>http://twitter.com/exceldailytip >>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>3. Excel tutorials at http://www.excel-macros.blogspot.com >>4. Learn VBA Macros at http://www.quickvba.blogspot.com >>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >>To post to this group, send email to excel-macros@googlegroups.com >> >><><><><><><><><><><><><><><><><><><><><><><> >>Like our page on facebook , Just follow below link >>http://www.facebook.com/discussexcel >> >-- >---------------------------------------------------------------------------------- > >Some important links for excel users: >1. Follow us on TWITTER for tips tricks and links : >http://twitter.com/exceldailytip >2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >3. Excel tutorials at http://www.excel-macros.blogspot.com >4. Learn VBA Macros at http://www.quickvba.blogspot.com >5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > >To post to this group, send email to excel-macros@googlegroups.com > ><><><><><><><><><><><><><><><><><><><><><><> >Like our page on facebook , Just follow below link >http://www.facebook.com/discussexcel > -- -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
