Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor https://excelvbatutor.com/ Master Excel VBA with free tutorials, examples, and personalized guidance. Perfect for beginners and advanced users looking to automate Excel. Wed, 03 Oct 2018 05:14:02 +0000 en-US hourly 1 https://wordpress.org/?v=6.8.5 Decision Making in Excel VBA https://excelvbatutor.com/index.php/2017/09/15/decision-making-excel-vba/ Fri, 15 Sep 2017 04:34:13 +0000 http://excelvbatutor.com/?p=2716 In Excel VBA, we can write decision-making codes based on certain conditions. There are two methods to write decision-making code in Excel VBA, using the If…..Then…Else syntax or using the Select Case…End select syntax. The syntaxes are exactly the same as VB6.  You need to use both the conditional operators and the logical operators together … Continue reading "Decision Making in Excel VBA"

The post Decision Making in Excel VBA appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> In Excel VBA, we can write decision-making codes based on certain conditions. There are two methods to write decision-making code in Excel VBA, using the If…..Then…Else syntax or using the Select Case…End select syntax.

The syntaxes are exactly the same as VB6.  You need to use both the conditional operators and the logical operators together with If…The…Else statements and Select Case statements.

For example

If sale>1000 Then

bonus=50*sale

Else

Bonus=0

End If

For more information, read the articles below:

Excel 2010 VBA Lesson 10: Using If…Then…Else

Excel 2010 VBA Lesson 11: Using Select Case

The post Decision Making in Excel VBA appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Creating Charts and Graphs in Excel VBA 2010 https://excelvbatutor.com/index.php/2015/10/27/creating-charts-and-graphs-in-excel-vba-2010/ Tue, 27 Oct 2015 02:56:48 +0000 http://excelvbatutor.com/?p=2150 In Excel VBA 2010, we can write code to create charts and graphs easily based on the data on the spreadsheet. Excel 2010 has made charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an … Continue reading "Creating Charts and Graphs in Excel VBA 2010"

The post Creating Charts and Graphs in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> In Excel VBA 2010, we can write code to create charts and graphs easily based on the data on the spreadsheet. Excel 2010 has made charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart sheet is the Chart object whereas the embedded chart is part of the shape collection for the worksheet. Learn more in the link below:

http://excelvbatutor.com/index.php/excel-vba-2010-lesson-24-creating-charts-and-graphs/

 

 

The post Creating Charts and Graphs in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> The Range Object in Excel VBA 2010 https://excelvbatutor.com/index.php/2015/03/22/the-range-object-in-excel-vba-2010/ Sun, 22 Mar 2015 10:53:32 +0000 http://excelvbatutor.com/?p=1893 Range is one of the most important and most commonly used Excel VBA 2010 object. The Range object contains two arguments that specifies a selected area on the spreadsheet. The syntax is Range(starting_cell,Ending_ Cell).  For example, Range(“A1:C6″) means the specified range is from cell A1 to C6. To select the specified range, the syntax is … Continue reading "The Range Object in Excel VBA 2010"

The post The Range Object in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Range is one of the most important and most commonly used Excel VBA 2010 object. The Range object contains two arguments that specifies a selected area on the spreadsheet. The syntax is Range(starting_cell,Ending_ Cell). 

For example, Range(“A1:C6″) means the specified range is from cell A1 to C6.

To select the specified range, the syntax is

Range(“A1:C6″).Select

where select is a method of the Range object

Learn more about the Range Object

The post The Range Object in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Using If…Then…Else in Excel VBA 2010 https://excelvbatutor.com/index.php/2014/10/05/using-if-then-else-in-excel-vba-2010/ Sun, 05 Oct 2014 14:35:47 +0000 http://excelvbatutor.com/?p=1775 In Excel VBA 2010, decision making involves the use of the If..Then…Else syntax to process data and display the output based on the fulfilment of certain conditions. To effectively control the VB program flow, we need to use If…Then…Else statement together with the conditional operators and logical operators. Read More……

The post Using If…Then…Else in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> In Excel VBA 2010, decision making involves the use of the If..Then…Else syntax to process data and display the output based on the fulfilment of certain conditions. To effectively control the VB program flow, we need to use If…Then…Else statement together with the conditional operators and logical operators.

Read More……

The post Using If…Then…Else in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Creating Animation in Excel VBA 2010 https://excelvbatutor.com/index.php/2014/07/23/creating-animation-in-excel-vba-2010/ Wed, 23 Jul 2014 01:11:19 +0000 http://excelvbatutor.com/?p=1768 Beside creating Excel VBA 2010 code for business and scientific calculations, it is also possible to creating some fun applications in Excel VBA 2010, including animation. Although professionals programmers might not be interested to write such applications, it is worth while trying them out as a hobby and for personal satisfaction. Read more….

The post Creating Animation in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Beside creating Excel VBA 2010 code for business and scientific calculations, it is also possible to creating some fun applications in Excel VBA 2010, including animation. Although professionals programmers might not be interested to write such applications, it is worth while trying them out as a hobby and for personal satisfaction.

Read more….

The post Creating Animation in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Creating charts in Excel VBA 2010 https://excelvbatutor.com/index.php/2014/05/28/creating-charts-in-excel-vba-2010/ Wed, 28 May 2014 05:38:49 +0000 http://excelvbatutor.com/?p=1760 Can we write code to create charts and graphs in Excel VBA 2010? Yes, you can. Excel VBA 2010 has included charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart … Continue reading "Creating charts in Excel VBA 2010"

The post Creating charts in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Can we write code to create charts and graphs in Excel VBA 2010? Yes, you can. Excel VBA 2010 has included charting engine as part of the Shape object. It is also an object by itself. We can create charts on a sheet of their own or embed them into an existing worksheet. The chart sheet is the Chart object whereas the embedded chart is part of the shape collection for the worksheet.

Read More……

The post Creating charts in Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Introduction to Excel VBA 2010 https://excelvbatutor.com/index.php/2014/02/17/1744/ Mon, 17 Feb 2014 08:07:34 +0000 http://excelvbatutor.com/?p=1744 Is creating Excel VBA in MS Excel 2010 as easy as in Ms Excel 2003 and older versions? The fact is Microsoft Excel 2010 looks similar to Microsoft Excel 2007 but both are considerably different from Microsoft Excel 2003. MS Excel 2010 employs interactive ribbon controls for the menu bar instead of the old menu … Continue reading "Introduction to Excel VBA 2010"

The post Introduction to Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Is creating Excel VBA in MS Excel 2010 as easy as in Ms Excel 2003 and older versions? The fact is Microsoft Excel 2010 looks similar to Microsoft Excel 2007 but both are considerably different from Microsoft Excel 2003. MS Excel 2010 employs interactive ribbon controls for the menu bar instead of the old menu structure. Fortunately, the Visual Basic Editor (VBE) remains largely the same as that of version 2003. However, finding the active-x controls on the ribbon control is not as obvious as in Microsoft Excel 2003. Learn how to create Excel VBA in MS Excel 2010 by following the link below:

http://excelvbatutor.com/index.php/excel-vba-2010-tutorial-lesson-1-introduction-to-excel-vba-2010-editor/

The post Introduction to Excel VBA 2010 appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Launching Excel VBA 2010 tutorial https://excelvbatutor.com/index.php/2013/12/17/launching-excel-vba-2010-tutorial/ Tue, 17 Dec 2013 12:09:47 +0000 http://excelvbatutor.com/?p=1598 Great news for all Excel VBA programmers, hobbyists, students and teachers! We are launching the latest Excel VBA 2010 tutorial today. This tutorial caters for those of you who are using Excel 2010. It is also suitable for some of you who are still using Excel 2007. Please check it out at: http://excelvbatutor.com/index.php/exccel-vba-2010-tutorial/

The post Launching Excel VBA 2010 tutorial appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Great news for all Excel VBA programmers, hobbyists, students and teachers!

We are launching the latest Excel VBA 2010 tutorial today. This tutorial caters for those of you who are using Excel 2010. It is also suitable for some of you who are still using Excel 2007. Please check it out at:

http://excelvbatutor.com/index.php/exccel-vba-2010-tutorial/

The post Launching Excel VBA 2010 tutorial appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Excel VBA Functions https://excelvbatutor.com/index.php/2013/08/23/excel-vba-functions-2/ Fri, 23 Aug 2013 07:07:56 +0000 http://excelvbatutor.com/?p=800 In Excel VBA, a function is similar to a procedure but the main purpose of the function is to accept a certain input from the user and return a value which is passed on to the main program to finish the execution. There are two types of functions, the built-in functions (or internal functions) and … Continue reading "Excel VBA Functions"

The post Excel VBA Functions appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> In Excel VBA, a function is similar to a procedure but the main purpose of the function is to accept a certain input from the user and return a value which is passed on to the main program to finish the execution. There are two types of functions, the built-in functions (or internal functions) and the functions created by the programmers, or simply called user-defined functions. We shall deal with built-in functions in this lesson and the user-defined functions in the next lesson.

Read On…..

The post Excel VBA Functions appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> Excel VBA Methods https://excelvbatutor.com/index.php/2013/08/22/excel-vba-methods/ Thu, 22 Aug 2013 09:31:29 +0000 http://excelvbatutor.com/?p=798 A method of an Excel VBA object normally do something or perform certain operations. For example, ClearContents is a method of the range object that clears the contents of a cell or a range of cells. For example, You can write the following code to clear the contents of certain range: Read on…….  

The post Excel VBA Methods appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]> A method of an Excel VBA object normally do something or perform certain operations. For example, ClearContents is a method of the range object that clears the contents of a cell or a range of cells. For example, You can write the following code to clear the contents of certain range:

Read on…….

 

The post Excel VBA Methods appeared first on Learn Excel VBA Online – Step-by-Step Tutorials & Courses | ExcelVBATutor.

]]>