In Excel VBA, you can refer to a specific variable (element) of an array by using the array name and the index number.ġ3 Function and Sub: In Excel VBA, a function can return a value while a sub cannot.ġ4 Application Object: The mother of all objects is Excel itself. ![]() A loop in Excel VBA enables you to loop through a range of cells with just a few codes lines.Ĩ Macro Errors: This chapter teaches you how to deal with macro errors in Excel.ĩ String Manipulation: In this chapter, you'll find the most important functions to manipulate strings in Excel VBA.ġ0 Date and Time: Learn how to work with dates and times in Excel VBA.ġ1 Events: Events are actions performed by users which trigger Excel VBA to execute code.ġ2 Array: An array is a group of variables. In this chapter, learn how to create a simple macro.Ģ MsgBox: The MsgBox is a dialog box in Excel VBA you can use to inform the users of your program.ģ Workbook and Worksheet Object: Learn more about the Workbook and Worksheet object in Excel VBA.Ĥ Range Object: The Range object, which is the representation of a cell (or cells) on your worksheet, is the most important object of Excel VBA.ĥ Variables: This chapter teaches you how to declare, initialize and display a variable in Excel VBA.Ħ If Then Statement: Use the If Then statement in Excel VBA to execute code lines if a specific condition is met.ħ Loop: Looping is one of the most powerful programming techniques. ![]() We hope they’ve given you a little inspiration for creative scheduling and polling for the classroom.VBA ( Visual Basic for Applications) is the programming language of Excel and other Office programs.ġ Create a Macro: With Excel VBA you can automate tasks in Excel by writing so called macros. These are just a few examples of how Doodle is employed in the classroom. Don’t forget to set limits, so the groups don’t end up too big! You can also print the list, or export it as an excel file, and have all the information down on paper. If everyone needs to get together for group projects, free text polls are the best way to go. Date polls are a great way to make decisions collectively. If you use the hidden poll feature, you can remove any bias. If you need to take a classwide poll to find the best day to go on a field trip, for example, you can send out a poll with all the options and let the students decide. If you have recurring meetings, you can just duplicate the poll and reuse the same email addresses. ![]() Create a Doodle poll and let those one-to-one meetings schedule themselves. The poll can also be hidden to keep everyone’s names and choices anonymous. You can set a limit on the poll that each option can only be chosen once, so you avoid double bookings. Create a poll with all the available 15-30 minute time slots and send it out to your students. ![]() Lots of teachers and professors use Doodle to schedule one-to-one meetings with their students.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |