|
- Excel VBA Programming - Variable Practice - Home and Learn
Home and Learn - Free Excel VBA Course 2 2 Excel VBA Variable Practice In the previous section, you learnt about variables To get the hang of variables, create a new blank spreadsheet Click on the Developer ribbon at the top of Excel On the Controls panel, click on View Code
- Excel VBA Programming - Practice 1 - Home and Learn
Home and Learn - Free Excel VBA Course 3 5 Excel VBA Practice 1 Suppose we had a spreadsheet with a person's name in cell A1 and a score in cell B1 We'd like to examine this score and see if it falls within a certain range If it's 85 or above, for example, we'd like to award a grade of "A" We want this grade to appear in cell C1
- Excel VBA Programming - Practice 2 - Home and Learn
Home and Learn - Free Excel VBA Course 3 6 Excel VBA Practice 2 Suppose we added another student to the spreadsheet from our previous lesson We want to set a grade for a score of 35 or below The grade will be an "F" However, because this is such a low score, we want to highlight the student's name, the score and the grade
- Excel VBA Programming - Practice 3 - Home and Learn
Home and Learn - Free Excel VBA Course 3 8 Excel VBA Practice 3 Add another name to your spreadsheet from practice 1 and practice 2 This time, type the name in cell A3 In cell B3, enter a score What we'll do is to put a grade in cell C3 and a some text in cell C4 We'll use Select Case Add another Sub to your code Call it SelectCaseTest
- Excel VBA Programming - Arrays - Home and Learn
Home and Learn - Free Excel VBA Course 6 1 Excel VBA Programming Arrays So far, you have been using variables that store one piece of information You have stored one Integer value, one Single value, or one String An array is a way to store more than one value under the same name An array looks like this when it is declared: Dim MyArray (4
- Home and Learn
In this course you'll learn how to create your own macros, so that you can bring your Excel skills to the next level, and put yourself ahead of the competition
- Excel VBA Programming - Add a Button to a Spreadsheet - Home and Learn
Home and Learn - Free Excel VBA Course 1 6 Adding Buttons to an Excel Spreadsheet In the previous lesson, you created a simple Sub in the code window In this lesson, you'll activate that Sub from a button on a spreasheet At the top of the VBA Editor, locate the Excel icon, just under the File menu: Click this icon to return to your spreadsheet
- Excel VBA Programming Variables - Home and Learn
Home and Learn - Free Excel VBA Course 2 1 Excel VBA and Variables In computer programming, you need to store things in memory, things like numbers and strings of text You store them so that you can retrieve them later and manipulate the numbers or strings of text in some way To store things in memory you use a variable
|
|
|