The estimated total time to take the Trip Planner parallel project course is between 8 and 12 hours. The time will vary depending on the person taking the course. The Trip Planner course is a workshop-type course; almost all the course lessons include exercises.
Lesson Title
|
Keywords and Phrases
|
|
1. Introduction to Parallel Project: Trip Planner
|
N/A
|
|
2. About Variables
|
tips on variables
|
|
3. Getting Toolbars You Will Need
|
Forms toolbar -- Drawing toolbar -- custom Align toolbar
|
|
4. Formatting and Naming the Main Worksheet
|
sheet shading -- column width -- sheet naming
|
|
5. Preliminary Words About Control Objects
|
control objects on a worksheet -- formatting, naming, aligning controls
|
|
6. Preparing a Worksheet for Data
|
data worksheet -- named ranges
|
|
7. Visual Basic Editor Setup
|
Parallel Project download -- VBE toolbars -- option explicit
|
|
8. Object Names for Worksheets
|
worksheet object name -- Project Explorer -- Properties Window
|
|
9. Insert and Name Modules
|
insert module -- name module
|
|
10. Deftypes and Option Declarations
|
DefTypes -- variable declaration -- variable types
|
|
11. Create Trip Legs
|
Parallel Project download -- For Each looping -- nested loops -- SpecialCells method
|
|
12. Load Costs for Legs
|
Array function -- looping through arrays -- Select Case -- For Each looping -- nested loops -- SpecialCells method
|
|
13. Create Destination Controls
|
buttons -- list boxes -- autoshapes -- naming buttons and list boxes
|
|
14. How to Multi-select List Boxes Using VBA
|
multi-select list boxes -- multi-select with code -- list box alignment
|
|
15. Destinations Code, Button and Init Sub
|
assign macro -- set statement -- public variables -- setting object variables
|
|
16. Destinations Code, Fill First List Box
|
fill list box -- AddItem -- RemoveAllItems -- ListIndex -- For Next loop -- With block
|
|
17. Destinations Code, Fill Second List Box
|
fill list box -- AddItem -- RemoveAllItems -- ListIndex -- For Next loop -- calling sub
|
|
18. Destinations Code, Last Row Function
|
finding last row -- SpecialCells method -- xlCellTypeLastCell property -- function arguments -- function return
|
|
19. Destinations Code, Use Last Row Function
|
using a function -- calling last row function
|
|
20. Assign a Macro to Destinations List Box
|
assign macro to list box
|
|
21. Create Button for Adding Trip Legs
|
Parallel Project download -- copy button -- clear macro from button -- rename button
|
|
22. Trip Legs List Box
|
create list box -- format list box -- multi selection type -- multi-select list box
|
|
23. Create Trip Legs AutoShape Label
|
copy autoshape -- autoshape label
|
|
24. Trip Legs Code: Add Lines to Init and DeInit Subs
|
object-type variable declaration -- public variable
|
|
25. Trip Legs Code: Add a Leg to Leg List Box
|
capture list box selection -- List property -- ListIndex property -- add record to list box -- AddItem method -- string concatenation
|
|
26. "Remove Selected Leg" Button
|
Parallel Project download -- Forms toolbar button -- Format Control -- button size
|
|
27. VBA Code for "Remove Selected Leg" Button
|
looping through list box -- For ii ... Next loop -- looping backwards -- ListCount property -- Selected property -- RemoveItem method
|
|
28. Create Move Leg Button
|
copy button -- resize button
|
|
29. Text Box and Label
|
create text box -- name text box -- text box text alignment -- copy autoshape
|
|
30. Moving Selected Leg to Text Area
|
text box code -- With block -- For Next loop -- List property -- ListCount property -- Selected property -- If Then block
|
|
31. Option Buttons for Transportation Mode
|
Parallel Project download -- option buttons -- group box -- aligning controls
|
|
32. Pseudo Code for Trip Mode Code
|
pseudo code
|
|
33. Modify Init and DeInit
|
public variables -- set object variable -- set option button reference -- set text box reference
|
|
34. Function for Returning Travel Cost
|
function -- function argument -- function return value -- Select Case -- For Each loop -- SpecialCells method
|
|
35. De-selecting Option Buttons and Adding to btnMoveLeg_Click
|
option button collection -- For Each loop -- calling a function -- option button Caption property -- concatenation -- de-selecting option button
|
|
36. Preparing Trip Cost Worksheet Area
|
Parallel Project download -- format worksheet -- named range
|
|
37. Assign Macros to Option Buttons
|
assign macro to option button
|
|
38. Code Triggered by Option Buttons
|
If..ElseIf..End If block -- capture option button selection -- define range dynamically -- build sum formula dynamically
|
|
39. Finish the Trip Planner Project
|
option button code
|
|
40. Trip Planner Conclusion
|
Parallel Project download -- challenge exercises
|
