Hi Harish, Welcome...
On Thu, Jul 28, 2011 at 2:10 AM, hanumant shinde <arsfan2...@yahoo.co.in>wrote: > awesome* *thanks* *Venkat > * > 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 <http://www.excel-vba.com/vba-prog-1-2-editor-project.htm>*), 3 ( >>> *Properties >>> Window<http://www.excel-vba.com/vba-prog-1-3-editor-properties.htm> >>> *) and 4 (*Code >>> Windows<http://www.excel-vba.com/vba-prog-1-4-editor-code.htm> >>> *). >>> >>> 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 > -- *Best Regards,* *Venkat* *Chennai* * * * * -- ---------------------------------------------------------------------------------- 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
