Left Scroll Microsoft Excel Training Banner Right Scroll

Microsoft Excel Training   |   Microsoft Excel VBA Training - Services

About Our Microsoft Excel Training Services

Microsoft Excel Training

Our Microsoft Excel training services cover the real world Excel topics needed to succeed in today's business and technology oriented world. EMAGENIT's Excel training services have been developed and refined from continually teaching the likes of NASA, Time Warner, BMW, Caterpillar, Boeing, Lockheed, Apple and Disney. In every single one of our training sessions, we adapt to the our customers needs. Our Microsoft Excel training focuses around your needs, not some preplanned syllabus that cannot be deviated from. Since EMAGENIT opened its doors in 1998, our Excel training has been continually refined and updated to include the latest Microsoft Excel techniques and Microsoft Excel technology.

Our Microsoft Excel training goes far beyond just canned run of the mill training topics encountered today. From the get go in our beginning level Excel training, our customers are exposed to important topics like proper data entry, basic formula design, basic data processing, how to use worksheet functions, proper worksheet layout and chart design. In our upper Excel training levels, our training goes after topics like advanced self-adjusting formulas, advanced data processing techniques, dashboards, visual interfaces, advanced pivot tables, modeling, and connecting Excel with external data sources. All of our Microsoft Excel training levels draw from our award winning Microsoft Excel software design experiences, so what is shown in our Excel training is what we have battle tested over and over again in our industry software since 1998. The best thing though about our Microsoft Excel training is the free repeats. No two EMAGENIT Excel training sessions are the same; you will want to revisit us again to see what is new.

About Our Microsoft Excel VBA Training Services

Microsoft Excel VBA Training

Our Microsoft Excel VBA training services cover everything you need to know about Excel VBA macro programming. Since 1998, our Excel VBA training knowledge has been built around our software design experiences for customers like NASA, Medtronic, Caterpillar, Time Warner and Northrup Grumman. We have designed just about every piece of software you can dream up in Excel and our Microsoft Excel VBA training reflects this. Our VBA training first of all focuses on our customer's needs, not some preplanned syllabus that has nothing to do with what is going on in the industry today. Our Excel VBA training shows you how to apply the latest and greatest Microsoft Excel VBA technology in ways that will increase your productivity a thousand fold. EMAGENIT loves it when our customers bring their problems to class so they can be worked on in class.

Our Microsoft Excel VBA training goes far beyond just canned run of the mill topics. In our beginning level VBA training, we review the basics of programming, logic, data processing, modeling and how to assemble Excel's tools and interfaces into a cohesive program. In our upper Excel VBA training levels, it is hang on for dear life as our training covers advanced data processing, advanced dashboard interfaces, integrating multiple data sources, integrating Excel VBA with .Net and that is just the beginning. Our motto is the harder the programming problem, the more fun it is to solve it. The best thing about our Microsoft Excel VBA training is our free repeats policy. No two EMAGENIT VBA training sessions are ever the same; you will want to use us as a support source and visit us again and again to continue learning.

Next Excel Training Dates - Business Next Excel Training Dates - Engineering | Science Next Excel Training Dates - Combined Audience

Beginning Excel Training

Beginning Microsoft Excel Training for Business

Check Schedule

Intermediate Excel Training

Intermediate Microsoft Excel Training for Business

Check Schedule

Advanced Excel Training

Advanced Microsoft Excel Training for Business

Check Schedule

Beginning Excel VBA Training

Beginning Microsoft Excel VBA Training for Business

Check Schedule

Advanced Excel VBA Training

Advanced Microsoft Excel VBA Training for Business

Check Schedule

Excel Data Processing

Excel Data Processing for Engineers and Scientists

Check Schedule

Beginning Excel VBA Training

Beginning Microsoft Excel VBA Training for Engineers and Scientists

Check Schedule

Advanced Excel VBA Training

Advanced Microsoft Excel VBA Training for Engineers and Scientists

Check Schedule

Excel Dashboard Training

Microsoft Excel Dashboards Training - Combined Audience

Check Schedule

Beginning Microsoft Excel Training

Our beginning Excel training shows you the essential Excel skills that are vital for your everyday business activities.

Our 1-day "hands-on" beginning Microsoft Excel training shows you the fundamentals of using Excel like entering data, autofills, flash fills, worksheet formatting, copying and pasting, basic formula construction, auto summing and more. Our beginning Excel training not only teaches you the basics of Microsoft Excel but the thinking and mechanics of how to apply it to your everyday problems and the future. Our Microsoft Excel training also covers Excel for Mac.

Intermediate Microsoft Excel Training

Our Intermediate Excel training shows you the basics of analyzing business information using formulas, worksheet functions and Excel's data processing tools.

Our 1-day "hands-on" intermediate Microsoft Excel training shows you Excel skills that apply to analyzing business information. Our intermediate Excel training topics include cell and range naming, building formulas using functions like VLOOKUP, SUMIF and IF; linking and managing worksheet information; organizing and analyzing worksheet data with Excel's data tools and functions; building professional charts; building pivot tables and pivot charts; cleaning worksheet text and working with text files; and linking Excel to other programs like Word and PowerPoint. Our Microsoft Excel training also covers Excel for Mac.

Advanced Microsoft Excel Training

Our advanced Excel training shows you how to use advanced Excel data tools, formulas and Excel visual tools to crunch business data and build displays.

Our 1-day "hands-on" advanced Microsoft Excel training shows you advanced Excel skills that apply to creating smart adaptive Excel business tools. Our advanced Excel training focuses on creating Excel analysis and data processing tools using advanced formulas, array formulas, logic, ActiveX controls, conditional formatting, data validation, pivot tables, pivot charts, Excel tables, relationships, and MS Query. Our workshop discusses the advanced aspects of these elements and how to assemble them in advanced ways. Our workshop also stresses how to create the advanced logic that allows these tools to operate autonomously and adapt to changing data. It also provides an introduction to Excel VBA macros. Our Microsoft Excel training also covers Excel for Mac.

Beginning Microsoft Excel VBA Training

Our beginning Excel VBA training gives you the skills that you need to start developing powerful data processing and analytical tools for business right away.

Based on our Microsoft Excel VBA software design experiences, our 2-day "hands-on" beginning Microsoft Excel VBA training provides a full review of the Excel VBA language including logic and shows you how to use it to control essential Excel features like workbooks and worksheets, copying and pasting, sorting and filtering, worksheet data processing, calculations, worksheet and VBA functions, worksheet formats, charts and pivot tables. Our beginning Excel VBA training also covers Excel for Mac.

Advanced Microsoft Excel VBA Training

Our advanced Excel VBA training shows you how to develop advanced data processing, data integration and amazing visual display tools.

Based on our 18+ years of Microsoft Excel design experience, our 3-day "hands-on" advanced Microsoft Excel VBA training shows you how to use VBA to command advanced Excel features, create advanced data processing tools that use multiple workbooks and data sources; create and control advanced dashboards that use ActiveX controls, worksheets, userforms and graphics; control the Windows folder system; process databases and text files, and control other programs like Word, PowerPoint and even VB.NET. It's everything we know. Our advanced Excel VBA training also covers Excel for Mac.

Microsoft Excel Data Processing Training Engineers | Scientists

Learn to build sophisticated Microsoft Excel data processing and visual tools for engineering and science using advanced formulas, Excel's data tools, Excel's visual components and ActiveX controls.

Our 1-day "hands-on" Microsoft Excel data processing workshop shows you how to organize, name and store large amounts of data on worksheets; build advanced formulas that think and adapt to changing worksheet data; create advanced Excel array formulas that solve tough data problems; build advanced data displays; process data using advanced formulas and Excel's statistical tools; link with external databases and text files; and construct advanced pivot tables. It also provides an introduction to VBA macros stressing custom Excel VBA worksheet functions. Taught by an engineer. Our Microsoft Excel training also covers Excel for Mac.

Beginning Microsoft Excel VBA Training Engineers | Scientists

Our beginning Excel VBA training shows you the programming skills that you need to start developing technical data processing and analytical tools in Excel right away.

Based on our Microsoft Excel VBA software design experiences, our 2-day "hands-on" beginning Microsoft Excel VBA training workshop shows from an engineering and science view how to use VBA to control key Excel features, format and process technical data, perform sophisticated calculations, create technical charts, create custom worksheet functions, manage large models and information, create report generation tools and much more. Taught by an engineer. Our Microsoft Excel VBA training also covers Excel for Mac.

Advanced Microsoft Excel VBA Training Engineers | Scientists

Our advanced Excel VBA training shows you how to develop advanced data integration, data processing, multi-language and visual display tools for engineering and science.

Based off our toughest Microsoft Excel VBA customer software projects, our 3-day "hands-on" advanced Microsoft Excel VBA training shows you from an engineering and science perspective how to use VBA to create advanced data processing tools; advanced technical models; advanced database tools; dashboards using ActiveX controls and userforms; interface with other programming languages like VB.Net, C and FORTRAN; and control other programs like Word and PowerPoint. Taught by an engineer. Our Microsoft Excel VBA training also covers Excel for Mac.

Introduction to Microsoft Excel VBA Training

Our Introduction to Microsoft Excel VBA training shows you the basics of how to use Excel VBA to develop useful Microsoft Excel tools.

Our 1-day "hands-on" Microsoft Excel VBA training shows you how to create Excel VBA macros that reduce your repetitive Excel tasks from hours to seconds. Our Excel VBA training shows you how to use the VBA language to command common Excel tasks like formatting, copying, pasting, inserting, deleting, sorting, data entry, and data filtering (AutoFilter, Advanced Filter). It also provides a basic review of programming including how to use variables, loops and logic in your code. It also discusses VBA procedure types, how to debug your code, how to perform calculations in your code and the strategy of using logic in programming. Our Microsoft Excel VBA training also covers Excel for Mac..

Microsoft Excel Dashboards Training

Our Microsoft Excel Dashboard training shows you how to create amazing Excel dashboards that let you visualize and integrate your Excel data.

Our 3-day "hands-on" Excel Dashboards training shows you the complete mechanics of how to create advanced Microsoft Excel dashboards. The dashboard types covered include various status and summary displays, project management displays, time lines, various chart gauges, various charts styles, various maps, color coding worksheets, pivot charts and any other dashboard you can dream up. It shows how to use all of Microsoft Excel's capabilities to construct these sophisticated dashboards and most importantly how to assemble them. It also demonstrates how to build the formulas that backup the dashboards as well as build custom VBA worksheet functions which are the ultimate formulas in Excel. Our Microsoft Excel training also covers Excel for Mac.
Microsoft Excel and Microsoft Excel VBA Webinar Training

Excel | Excel VBA Webinars

Our Microsoft Excel Webinar and Microsoft Excel VBA Webinar training is broadcast live and is taught "hands-on". We can broadcast our Excel Training anywhere in the world at any time. We can also use our webinars for your company onsite training. Call us for more details at 1.805.498.7162.
Microsoft Excel and Microsoft Excel VBA Public Seminar Training

Excel | Excel VBA Seminars

Our Microsoft Excel Seminar and Microsoft Excel VBA Seminar training is taught "hands-on" and is also broadcast live as a webinar. Our workshops are never canned and are adjusted to our customers training needs during class.
Microsoft Excel and Microsoft Excel VBA Onsite Training

Excel | Excel VBA Onsites

Our Microsoft Excel and Microsoft Excel VBA Company Onsite training is customized for our customers particular Microsoft Excel needs. They are taught "hands-on" and can also be broadcast live as a webinar anywhere at any time.
Microsoft Excel and Microsoft Excel VBA Training Schedule

Excel | Excel VBA Training Schedule

View all of our Microsoft Excel training and Microsoft Excel VBA training offerings. Our workshops are presented as hands-on public seminars or can be broadcast live as a webinar to anywhere in the world.
Microsoft Excel and Microsoft Excel VBA Training Self-Study Manuals

Excel | Excel VBA Manuals

View all of our Microsoft Excel and Microsoft Excel VBA self-study manuals. Our self-study manuals are derived from our almost twenty years of Microsoft Excel training and software design experiences.
Microsoft Excel Training and Microsoft Excel VBA Workshop Skill Levels

Excel | Excel VBA Workshops Guide

View the skill levels required for all of our Microsoft Excel training and Microsoft Excel VBA training. All of our Excel training is customized to our customers needs in class so you do not need to be an expert to take it.

Award Winning Microsoft Excel Software Design - Services

NASA AwardEMAGENIT creates award wining software in Microsoft Excel for NASA, The US NAVY, Caterpillar, Time Warner Cable and Northrup Grumman.

We can build just about anything in Microsoft Excel, but we specialize in advanced modeling, visual interfaces, data processing (data mining), report generation and dashboard construction. The harder the challenge, the happier we are. We love producing a solution when other companies said it could not be done. For example, our award for helping design the Mars Rover software in Excel.
 
Over the years, we have pushed Microsoft Excel software design to its limits providing tools for business, engineering and science related tasks. Along this journey, we have also realized that Microsoft Excel macros coupled with other design tools like Visual Basic .NET, Web ASP, JavaScript and other programs like Microsoft Word and Microsoft PowerPoint allowed hybrid tools to be developed that were quick in design yet more powerful than using just Microsoft Excel macros alone. The idea is to use each environment's strengths and making them act as one seamless tool. At EMAGENIT, we do all of our programming in the US which means your proprietary information remains secure. We work continuously with businesses as well as the technical communities and we provide a life long guarantee so if something goes wrong down the road, we will always fix it. To learn more about our software design click here.

About Our Real World Microsoft Excel Training and Microsoft Excel VBA Training

Real World Microsoft Excel and Microsoft Excel VBA TrainingPronounced "Imagine-It", we specialize in Microsoft Excel training and Microsoft Excel VBA training.

We have been providing Microsoft Excel training since 1998. We offer a wide variety of Microsoft Excel training and Microsoft Excel VBA training workshops that take you from the beginning to the most advanced Excel power use. Our training experience includes companies and organizations like Time Warner, NASA JPL, Caterpillar, USDA, AMGEN, BMW, Lockheed, The US Air Force and The US Navy.

At EMAGENIT, we have been personalizing our training and problem solving since our very first day of business. Our innovative style of teaching provides you with the best hands on training in the industry. You will be amazed at how much you can learn in such a short amount of time. Our training programs are taught onsite at your workplace, through a live broadcast webinar you can come to one of our public workshops. Anytime you take a course from us, you can come back any time and retake it free, an exceptional value (free repeat details). To learn more about EMAGENIT click here.

Microsoft Excel Add-Ins Version 9.0

Microsoft Excel Add-Ins for Data Processing Our Microsoft Excel Add-Ins have been redesigned and improved to tackle your rogue data and repetitive task Excel problems.

Our Microsoft Excel Add-Ins are designed to tackle the tough data problems and repetitive tasks that you encounter in Microsoft Excel. From automatically time stamping worksheets, to comparing different tables, to cleaning data so it can be used effectively on worksheets, they have you covered. If you have an idea after reading about our add-ins, click on the suggestion link and fill out the form. If we can use your idea, you get a free version of the software for as long as we make them. To view our list of Excel Add-Ins, click here.

Microsoft Excel Training Tip of the Week

Microsoft Excel Tip of the WeekOur Microsoft Excel training tip of the week provides useful information that lets you work easier.

How to Write a VBA Sub Procedure (Macro) That Controls Excel

Microsoft Excel comes standard with a programming language called VBA or Visual Basic for Applications. This programming language, commonly referred to as macros, is what you use to automate Microsoft Excel with. Individuals will also call this language VB script, VB and VBA macros to name a few. If you here the words VB.Net, that is VBA's big brother. The power of coupling VBA and Excel together can really not be overstated. Constantly when EMAGENIT puts the two together, they regularly out perform tools costing hundreds of thousands of dollars to buy and maintain. Add to that the fact that Excel has already been developed and you can tap into that pre-built engine and graphics, drastically reduces project build time and cost. And flat out the Excel-VBA combination can do things that you just can not do in .Net (VB, C Sharp...) and if you can, the development time is horrendous. All that said, EMAGENIT uses all the tools just mentioned to develop with and they are all excellent in their own areas, we just find a lot of times that the Excel VBA combination for data processing and dashboard design is hard to beat and comes through again and again. And if you do need the capabilities of the .Net environments, you can just run them from VBA (topic for much, much, much later down the road but now at least you know it can be done so you can plan).

So after that introduction, how do you write a VBA procedure that commands Excel. Well first have only one workbook open in Excel, having multiple workbooks open when learning how to use VBA can be quite confusing. Next press Alt+F11 to activate the Visual Basic Editor. In the Visual Basic Editor, proceed to the View menu and select View/Project Explorer . The Project Explorer window will appear by default on the left-hand side of the VBA Editor window.

Calculation Mode

In the VBA Editor, proceed to the View menu and select View/Project Explorer.

In the Explorer window, find your workbook's VBA project, look in the ()'s for the name of your workbook, and click within the project's tree elements. This step identifies the project where you want to insert the module we will insert and is necessary if you have multiple workbooks open. Just a note here, when you create a workbook, the VBA project is already part of the workbook file. It is made for you automatically. For any one coming from another programming environment let me save you the time, Excel VBA does not allow you to create any other type of project but the one seen. Next proceed to the Editor menu and select Insert/Module. This will insert a module in the Editor window on the right-hand side of the Project Explorer window. The module you just inserted is where you will type your VBA code. Think of it as a Word document and you will use the same basic typing skills to type in it that you do in Microsoft Word. There are two other types of modules in Excel VBA to use, but do not worry about those right now as you will not need them for a long time. The module you just inserted, think of it as the town square where everybody can easily communicate without any hassles. This type module will be your workhorse in Excel VBA.

Calculation Mode

In the Explorer window, find your project and click anywhere within its tree elements. Next proceed to the Editor menu and select Insert/Module.

The inserted module will appear in the Explorer tree under the Modules folder. If you do not see the folder, click the orange/yellow Folder button at the top of the Explorer window. To control the module, double click on its module icon in the Explorer window to view it and click on its (x) close button in the upper right hand corner of its window to close it. You always want your module window maximized for viewing purposes so if you see it in a window format, double click on its caption bar to maximize it. You can also click its window maximize button also. One last thing, when you save the workbook, you save the module code. When you open the workbook, the code is opened. To save your workbook, go back to Excel and save the workbook as an Excel Macro-Enabled Workbook file type or you will strip the code out of the workbook when it is closed. You do not have to save a module before closing it as it does not effect the code. To toggle between Excel and the Editor, use the buttons on the Windows task bar at the bottom of Windows. One other thing, when you develop a VBA program in Excel, you pick a workbook to store all the code in you will use. The code does not necessarily have to be in the same workbook as information you will be accessing. In our example here, the data we will use will be in the same workbook as the data.

Calculation Mode

To activate a module, double click on its module icon in the Editor window and close it by clicking its Close button.

Next click in the module window. You must create a procedure, commonly referred to as a macro, to command Excel. All of the code you type will go inside of a procedure. The basic exceptions are what they call module level declarations and comments. You will not be worrying about module declarations right now.  Comments are notes to yourself about what your code is doing, you will learn to document your code using comments as they help a great deal in figuring out what your code is doing when revisiting it 3 months down the road. They always begin with an ' apostrophe and turn green when done typing.

There are two basic types of procedures you will worry about at this stage, Sub procedures and Function procedures. Sub procedures just run and do a series of tasks and calculations then end while Function procedures are designed to do a series of tasks and calculations and return a value back. Just think of a worksheet function and you have the general principle down. As a general rule when first starting out, you will write a Sub procedure to command Excel and then branch out from there. So in the module type: Sub copypaste and press Enter. A pair of ()'s will appear after copypaste and End Sub will also appear. Click before End Sub and hit Enter about 5 times and give yourself some room to type. The name copypaste is the name of the procedure, that is how they are tracked, and as a general rule, do not repeat procedure names in your project. The names you type in a program can basically contain alphanumeric characters and an _ underscore and that is about it. Do not put spaces in your names and they can be not be longer than 255 characters. As you type, you will notice words that turn blue. These are reserved keywords in VBA and do not use them for names. VBA is not a case sensitive language when typing names although the logic structures your write in it are when comparing text.

Calculation Mode

Type Sub copypaste and press Enter.

When commanding any program, they always have a hierarchy to them. To visualize this, think of a program as a building with floor levels and a stair case. Your job is to find what floor level does the job for you in the building, walk down the staircase to it, stop, and get somebody on the floor to do your task. To command a program in general, you always start at the top floor level of the building and go down. This level structure concept in your code is represented by a series of commands separated periods. Each command walks down to a new level of the program till you reach your target level, then the last command typed is what you are doing. So the first thing you have to figure out when commanding a program is what level controls what you want to do. The next task is to figure out is how to get there. So in our problem here, we are going to copy and paste a value from one worksheet to another. So in our case the first thing we figure out is what Excel program level controls this functionality which is the Range level. Note that the levels you go through in a program will be tracked mostly by name so be sure to insert two worksheets in your workbook and name them Data and Output. Data will contain the data to copy and output is where we will paste it to. Next on the Data sheet type 100 in cell A1 and press Enter.

Calculation Mode

Make two worksheets and name them Data and Output. On the Data sheet in cell A1 type 100.

Proceed back in the Editor (Windows task bar or Alt+F11 again) and between the Sub and End Sub type:

Application.ThisWorkbook.Worksheets.Item("Data").Range("A1").Copy
Application.ThisWorkbook.Worksheets.Item("Output").Range("B5").PasteSpecial

You can see the code stepping down through the structure of the program, Application is the top level of the program, Range is our target and after the last period is what we are doing, copying and pasting. Generally one line of code represents an operation in Excel so in order to copy and paste we needed two lines of code. They tend to call the Command.Command.Command leading down to the Copy and PasteSpecial the "path" or hierarchy. As stated earlier, your VBA code will generally not be housed in the same workbook as your data. As matter of fact, the workbook that houses the VBA code is really not important in theory. What is important are the paths you create and how they target the different parts of Excel. It is all in the path so remember that one key rule. Also when creating complex data systems like most of you want to create, you are going to be opening and closing hundreds of workbooks, generating new report workbooks, charts... so you will always lock on to your program elements you want to command by using full paths. You will read that you can use sometimes drop part of the path due to some Excel element being active, this is the kiss of death to a data processing system as you will loss track of what you are trying to command very quickly. And remember there are techniques that you can use that scan for data workbooks that you do not know the name of and techniques that can rip through thousands of workbook files in folders. Learn first how to command things that are in the workbook that house your code, then learn the techniques to lock on to information external to the code workbook.

Now to run the code, click anywhere inside the boundaries of the procedure, press the F8 key and keep pressing it till the yellow line disappears after End Sub. This is called Break Mode and helps you step through the code line by line and debug it. If you press the F5 key, it will just run the code without stepping through it. On the Debug menu, you can see the debugging commands and the shortcut keys that activate them. You will need to learn how to debug before writing any programs. It is the most important skill to learn when programming. One note, you cannot run any code till you correct the code lines that are red. These are called syntax errors and you must correct them. Generally what happens is you left off a . or , or " or (. If you are pressing F8 and a dialog box appears, this is called a run time error and can mean a couple of basic things. First a command is out of sequence in the ...., the name inside the ""' is wrong, you misspelled the command or it try's to do something that cannot be done. The last type of error encountered is called a logical error. It means the program is doing something, but not what you want it do. These are the hardest to track. Therefore write your code in small blocks, test and debug constantly and be patient.

Calculation Mode

Type the code in between the Sub and End Sub, click inside the procedure and press the F8 key to step through the code running it and debugging it.

Now the terminology transfer. When reading about controlling programs, most modern ones are developed as a series of Class modules. These classes contain procedures in them just like what we typed. When the program powers these classes up, they create what are called objects (what we called the levels of the program earlier). The classes are their blueprints. So when you hear the word object think Class module. If you know the class and its procedures, you know how to control the objects made from them. Also the words properties and methods, they are categories for the procedures in the classes. They also call class procedures members. The commands we just typed in the Command.Command.Command structure are actually procedures from these classes. Typing code boils down to knowing the syntax, the grammar of what to type. This where you will spend your time and lots of it. Your computer will develop nick names during this time period that cannot be stated on this website without parental warning. Just make sure nobody hears you when scolding your computer about how it has let you down yet again. Just joking. Anyways if you know what type of procedure in a class you are going after, you know how to type the code because there are rules for typing each procedure type in your code. Learn these rules and you will know how to type the code that controls the program. The classes and their procedures that make up Excel are found under View/Object Browser.

Last you will also want to learn about variables, logic and loops. These are the essentials of a program and allow it to operate correctly and perform amazing tasks. Logic provides the brains for the program and give the ability to make decisions. Variables are used to store/retrieve information in the program while it is running. Loops are the engine of your code that you write whenever you have more than one item to go through. For example, if you have 500 files to go through in a folder, it will be a loop. If you have to process 50,000 lines of worksheet rows and cells, it will be a loop. Learn these structures well as they form the core of advanced programs.

Last to make a button to run your Sub, proceed to a worksheet, right mouse click on a picture or drawing shape and select Assign Macro... On the Macros dialog box that appears, select the Sub procedure name to assign in the center box and click OK. Click off the picture or shape to activate the button and click back on it again to run the procedure. To edit the button, right mouse click over the shape to deactivate the procedure run and then edit. Phew signing off!!!


To learn more about Excel VBA, check out our Beginning Excel VBA for (Engineering and Science, Business) workshops.

Microsoft Excel Training Resources Page - Free Help

Excel Resources PageOur Microsoft Excel Resources page provides useful information and tips about Microsoft Excel.

It discusses basic Excel operations like writing formulas, running worksheet functions, typing data and using worksheets. Also discussed is how to use our favorite worksheet functions in real life situations and the syntax behind writing them in formulas. Our resources page also discusses why you want to use Excel VBA (macros) in Excel and the basics behind its operation. To view our resources page click here.


Site Map  Mobile Site

Copyright © 2002-2015

EMAGENIT All Rights Reserved