Register now to access 7 million high quality study materials (What's Course Hero?) Course Hero is the premier provider of high quality online educational resources. With millions of study documents, online tutors, digital flashcards and free courseware, Course Hero is helping students learn more efficiently and effectively. Whether you're interested in exploring new subjects or mastering key topics for your next exam, Course Hero has the tools you need to achieve your goals.
17 Pages
Intro to VBA
Course: ITSK 2314, Fall 2009School: Clayton
Rating:
Word Count: 160
Document Preview
to Intro VBA ITSK2314 Lecture 2 Agenda VBA vs. Macros "Finding" the IDE A small application A macro example Where to get help VBA vs. Macros Macros record activities Often not generalizable Only use existing capabilities Useful to obtain "how do I do this" Write new methods/modules VBA allows you to extend capabilities "Finding" the IDE...
Unformatted Document Excerpt
Coursehero >> Georgia >> Clayton >> ITSK 2314Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
Course Hero has millions of student submitted documents similar to the one
below including study guides, practice problems, reference materials, practice exams, textbook help and tutor support.
to Intro VBA
ITSK2314 Lecture 2
Agenda
VBA vs. Macros "Finding" the IDE A small application A macro example Where to get help
VBA vs. Macros
Macros record activities
Often not generalizable Only use existing capabilities Useful to obtain "how do I do this" Write new methods/modules
VBA allows you to extend capabilities
"Finding" the IDE
AltF11 Tools | Macro | Visual Basic Editor
The VBA IDE
Code Complete
Invoking Functions/Methods
Errors & Syntax
What I Expect
Case sensitivity matters name
Variable Prefix type
Define variables (Option Explicit) Whitespace & indentation Comments (single quote `)
Clear names
Saving & Running the Code
When you save the document, you save the code Tools | Macro | Macros... (AltF8)
Macros
Record your actions Often not very extensible
Can be usefu...
Textbooks related to the document above:
Find millions of documents on Course Hero - Study Guides, Lecture Notes, Reference Materials, Practice Exams and more.
Course Hero has millions of course specific materials providing students with the best way to expand
their education.
Below is a small sample set of documents:
Below is a small sample set of documents:
Clayton - ITSK - 2314
Date Payee 6/3/2004 Walmart 6/7/2004 Kmart 6/23/2004 CCSU bookstore 6/30/2004 PhatKrunk.com 6/3/2004 Walmart 4/7/2004 Verizon 6/15/2004 United BMWAmount $45.60 $10.90 $139.99 $95.44 $(90.55) $100.00 $500.99Total $45.60 $56.50 $196.49 $291.93 $201
Indiana University-Purdue University Fort Wayne - CS - 472
/ DESCRIPTION: This Java class implements a weak / counting semaphore as described in a paper by Stephen / Hartley, SIGCSE Bulletin, Vol. 31, Num. 1, March 1999, / pp. 58 62. / class Semaphore{ / private int value = 0; private int waitCount = 0; pri
Indiana University-Purdue University Fort Wayne - CS - 472
Review outline for Final ExamChapter 8 page replacement policies: Optimal, LRU, FIFO, Clock. Study Fig. 8.15 (p369) working set resident set policy fixed/variable and local/global L=S criterion Chapter 9 Uniprocessor scheduling dispatcher policies:
Indiana University-Purdue University Fort Wayne - CS - 472
Chapter 10: Mulitprocessor SchedulingCS 472 Operating Systems Indiana University Purdue University Fort Wayne1Multiprocessor Systems ClassificationLoosely coupled or distributed multiprocessor system or clusterEach processor has its own memor
Indiana University-Purdue University Fort Wayne - CS - 472
Chapter 18: Distributed Process ManagementCS 472 Operating Systems Indiana University Purdue University Fort Wayne1Distributed Process ManagementNote: Chapter 18 is an online chapter and does not appear in the textbookAvailable under "Online
Allan Hancock College - PROJECT - 4004
CHEMICAL PRODUCT DESIGN:LOW CARBOHYDRATE HONEYINTERIM DEVELOPMENT PLAN22 September 2004Team Members: Supervisor:Jordan Mellick Ching Wui Chua Jim Litster1Executive SummaryThe project has proceeded along the following lines of investigat
Allan Hancock College - PROJECT - 4004
J&K TECHNOLOGIESBUSINESS PLAN 2004 - 2008PROJECT:LOW-CARB HONEYAUTHORS: JORDAN MELLICK, CHING WUI CHUAJ&K TechnologiesBusiness PlanEXECUTIVE SUMMARYJ&K Technologies is a company devoted to the production of superior products through res
RIT - P - 07009
Project Readiness Package Guidelines OBJECTIVE:Rev 1Provide information necessary to relate customer requirements and expectations in terms of project deliverables including their time frame. As such it will provide the information necessary duri
RIT - P - 07009
Warfarin (Coumadin) remote programmed automatic home medication dispenser: Four million people in the US are taking warfarin anticoagulation for a variety of medical conditions that place them at risk for intravascular blood clot formation including
RIT - P - 07009
Senior Design Project Data SheetProject # Project Name Project Track Project FamilyP07009Start TermWarfarin Automatic Home Medication DispenserTeam GuideBio-Engineering & Assistive Devices TrackProject SponsorP07009 BioEngineering & Assi
RIT - P - 07009
Senior Design Project Roles Responsibilities MatrixName Abramo, Christopher Amin, Ntongho Columbare, Nicholas Lam, Albert Strandburg, Alan Yeung, GordonP07009: Warfarin Automatic Home Medication Dispenser Project Area of Responsibility Functional
RIT - P - 07009
P07009 - Warfarin Automatic Home Medication Dispenser Needs Assessment Senior Design I Winter 20062 1. Easily transportable. 2. Enclosed and latched with tamper evident indicator. 3. One month supply of warfarin. 4 compartment model - 4 bulk compart
Allan Hancock College - PROJECT - 4004
Membrane Design Calculator Equilibrium Reaction Options Reaction Set:Dehydrogenation Of Cyclohexane: C6H12 <-> 3H2 + C6H6Final Values Membrane In Out In Out Out Not sep Out In Out In Out Out Not sep Out 0.5 0.2 0.0 0.0 0.3 0.0 0.9 40.1 15.9 0.0
RIT - P - 07009
ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32Task Name Start of Winter Quarter Project Selection Workshop 1: Know the Customer & Your Team Course Logistics Team Ice Breaker Review PRP & Project Background
RIT - P - 07009
ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32Task Name Start of Winter Quarter Project Selection Workshop 1: Know the Customer & Your Team Course Logistics Team Ice Breaker Review PRP & Project Background
RIT - P - 07009
Customer Requirements Easily Transportable Enclosed and Latched Separate Compartments Easy and Quick Loading Clearly Labeled Pill Bins Spill Proof Programmable Interactive Interface Easy to Read Color Screen Visible Large Button Rapid Delivery of Dos
RIT - P - 07009
Metric # Need #s 1 1 2 1 3 2 4 3,4,5 5 11,15 6 11,22 7 4 8 7,8,10,12,15 9 9,10, 10 16,19,20,21 11 16,19 12 11,15,17,18 13 13,14 14 6 15 6Metric Weight Volume Sealed and Tamper Evident Bin Size Dispensing Time Operating Noise Level Load Time Custome
RIT - P - 07009
In this section enter a 1-2 sentence description of the fundamental problem your senior design project is trying to solve.Problem Statement:Frequent coordination between the physician, patient, and pharmacist is time consuming, inconvenient, and p
RIT - P - 07009
Concept Generation - "Black Box"Energy Material Control / FeedbackOutputInputPower Data PillsPills A/VPill DispenserConcept Generation - "Function Diagram"Energy Material Control / FeedbackInputPower Data Pills 0 0Accept power fr
RIT - P - 07009
Senior Design I Project # P07009 Warfarin Automatic Home Medication Dispenser Date Revised: 1/10/2007 Identification and Justification of Critical Subfunctions Power Conditioning Accept power from external source Device is constructed of electrical
RIT - P - 07009
A Selection CriteriaVolume Dispensing Time Reliability Potential Pill Damage Manufacturability Concept Part Lead Time # of Motors Simplicity Balance of Design Cost Net Score Continue?B Tray Feed-1 0 -1 -1 1 0 1 0 1 0 YesPusher (reference)0 0 0
RIT - P - 07009
Automatic Home Medication DispenserProject # P07009 Team Guide - Dr. Daniel Phillips Project Sponsor - Dr. Michel Berg Team Members Alan Strandburg Chris Abramo Ntongho Amin Gordon Yeung Nick Columbare Albert LamProject Background Warfarin is an
RIT - P - 07009
Automatic Home Medication DispenserProject # P07009 Team Guide - Dr. Daniel Phillips Project Sponsor - Dr. Michel Berg Team Members Alan Strandburg Chris Abramo Ntongho Amin Gordon Yeung Nick Columbare Albert LamProject Background Warfarin is an
Hudson VCC - STAT - 051
Comparing Categorical Variables.Two Way or Contingency Tables.An experiment has a two-way, or block, design if two categorical factors are studied with several levels of each factor. Two-way tables organize data about two categorical variables obta
Hudson VCC - STAT - 051
RIT - P - 07009
Mechanical Bill of Materials Quantity 1 1 1 1 1 1 1 1 6 6 1 1 6 6 6 6 6 6 1 6 6 2 1 Part Name Upper Body Lower Body Cup Plate Servo Holder Side Plate Left Side Plate Right Ramp Base Pill Plate Servo Link Tube Holder Guide Plate Bottom Hub Top Hub Pil
Hudson VCC - STAT - 051
Summary two-way table: High school students were asked whether they smoke and whether their parents smoke.
RIT - P - 07009
Warfarin Automatic Home Medication Dispenser Senior Design I Project # P07009 Team 7009Alan Strandburg, ME Gordon Yeung, ME Chris Abramo, ME Nick Columbare, EE Ntongho Amin, EE Albert Lam, CEDesign Review HandoutProject Background:Warfarin is a
Bryant - QTM - 7020
Spring Semester 2002 QTM7020 Decision Support Systems T 6:30-9:15 with a 15 minute break Dr. Alan Olinsky Work Phone: 401-232-6266 Home Phone: 401-946-0338 E-Mail: aolinsky@bryant.edu Web page: blackboard.babson.edu or web.bryant.edu/~aolinsky Offic
Bryant - QTM - 7020
RIT - P - 07009
Warfarin Automatic Home Medication Dispenser Senior Design I Project # P07009 Team 7009Alan Strandburg, ME Gordon Yeung, ME Chris Abramo, ME Nick Columbare, EE Ntongho Amin, EE Albert Lam, CEDesign Review HandoutProject Background:Warfarin is a
Bryant - QTM - 7020
Bryant - QTM - 7020
Bryant - QTM - 7020
Bryant - QTM - 7020
Bryant - QTM - 7020
Bryant - QTM - 7020
Bryant - QTM - 7020
Assignment example from ASW Ch 10 slides Projects B 50 28 35 25 Projects B 0 1 0 0 1 = Demand Distance 1 69 = 1 0 0 0 1 1 = 1 36 30 32 25A Subcontractor Westside Federated Goliath UniversalC 16 18 20 14A Subcontractor Westside Federated Goliath
RIT - P - 07009
ID 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31Task Name SDII - Project P07009 - Warfaring Home Medication Dispenser Start of Spring Quarter Phase 3 Detail Design Week 1 - Finalize Full System Design Weekly Te
Bryant - QTM - 7020
Shipping PlanBavarian Motor Company Ship 75 0 0 75 50 25 0 0 35 40 From 1 Arnold 1 Arnold 2 SuperShelf 2 SuperShelf 3 Thomas 3 Thomas 3 Thomas 4 Washburn 4 Washburn 4 Washburn To Unit Cost 3 Thomas $5 4 Washburn $8 3 Thomas $7 4 Washburn $4 5 Zrox
Bryant - QTM - 7020
Problem 10.30 Input Data Bank's Option to Approve Customer Loan If Customer Defaults Annual Interest Rate for Loan If Customer Does Not Default Bank's Option Not to Approve Customer Loan Annual Rate of Return for Bonds Annual Earnings from Investing
Bryant - QTM - 7020
Three decision makers have assessed utilities for the problem whose payoff table appears below. s1 500 200 -100 0.2 s2 100 150 200 0.6 s3 -400 100 300 0.2d1 d2 d3 probabilityPayoffa.utilityIndifference Probability for Person u(A) B u(B) C 5
Bryant - QTM - 7020
Production PlanWeedwacker Company Number to Make Number to Buy Cost to Make Cost to Buy Total Available Total Needed Resources Req'd Production Assembly Packaging Electric 30,000 0 $55 $67 30,000 30,000 0.20 0.30 0.10 Gas 10,000 5,000 $85 $95 15,00
Bryant - QTM - 7020
Production PlanWeedwacker Company Number to Make Number to Buy Cost to Make Cost to Buy Total Available Total Needed Resources Req'd Production Assembly Packaging Electric 30,000 0 $55 $67 30,000 30,000 0.20 0.30 0.10 Gas 10,000 5,000 $85 $95 15,00
Bryant - QTM - 7020
Shipping ReportSentry Lock Corp. Unit Shipping Costs to Distribution Center in: Dallas Denver St. Louis $1.75 $2.00 $2.10 $1.50 $1.60 $1.00 $1.85 $1.25 $1.50 $1.60 $1.75 $2.00Plants Macon Louisville Detroit PhoenixTacoma $2.50 $1.85 $2.30 $1.90
Bryant - QTM - 7020
Fidelity Savings & Loans - Outputs -New Loans Satisfaction 770 92 780 94 790 93 730 82 910 98 860 90 880 89 970 99 770 94 930 91 0.0000 0.0012 - Inputs -Labor Hrs Op. Costs 3.73 6.34 3.49 4.43 5.98 6.31 6.49 7.28 7.09 8.69 3.46 3.23 7.36 9.07 6.38 7.
Bryant - QTM - 7020
SHIFTS 11:00AM3:00PM 11AM 12N 1PM 2PM 3PM 4PM 5PM 6PM 7PM 8PM 9PM #starting shift 1 1 1 1 12:00N4:00PM 1 1 1 1 1:00PM5:00PM 2:00PM6:00PM 3:00PM7:00PM 4:00PM8:00PM 5:00PM9:00PM1 1 1 11 1 1 11 1 1 11 1 1 1 4 01 1 1 1810106:00PM10:
Bryant - QTM - 7020
small#ADDIN? 0favorable77.0% 0Decision #ADDIN?medium#ADDIN? 0large#ADDIN? 0mkt research#ADDIN? 0Chance #ADDIN?small#ADDIN? 0unfavorable23.0% 0Decision #ADDIN?medium#ADDIN? 0large#ADDIN? 0PDCDecision #ADDIN?
Bryant - QTM - 7020
Microsoft Excel 9.0 Answer Report Worksheet: [Book4]Sheet1 Report Created: 6/4/01 8:51:42 PMTarget Cell (Min) Cell $E$10 CostNameOriginal Value Final Value 0 800Adjustable Cells Cell Name $C$4 No. of tons product A $D$4 No. of tons product B
Bryant - QTM - 7020
clear open 85.0% 0 weather #ADDIN? overcast rain prob 4.24 highway condition #ADDIN? clear jammed 15.0% 0 weather #ADDIN? overcast rain80.0% 0#ADDIN? #ADDIN?20.0% 0 0.0% 0#ADDIN? #ADDIN? #ADDIN? #ADDIN?10.0% 0#ADDIN? #ADDIN?30.0% 0 60.0
Bryant - QTM - 7020
Microsoft Excel 9.0 Answer Report Worksheet: [Book3]Sheet1 Report Created: 6/4/01 8:32:52 PMTarget Cell (Max) Cell $E$10 ProfitNameOriginal Value Final Value 1600 1600Adjustable Cells Cell Name $C$4 No. of tons Fuel additive $D$4 No. of tons
RIT - P - 07009
Dr.DanielPhillips FacultyGuideAlanStrandburg MechanicalEngineerChristopherAbramo MechanicalEngineerGordonYeung MechanicalEngineerAlbertLam ComputerEngineerNtonghoAmin ElectricalEngineerNicholasColumbare ElectricalEngineerSponsoredby:Dr.
RIT - P - 07009
Multidisciplinary Engineering Design ProgramNon-secured accessAnonymous User View User Info Secured loginSuper-projects:EDGE About Home node Scripts Resources About Home node Scripts Senior Design I About Home node Scripts TEAK About
RIT - P - 07009
Multidisciplinary Engineering Design ProgramNon-secured accessAnonymous User View User Info Secured loginSuper-projects:EDGE About Home node Scripts Resources About Home node Scripts Senior Design I About Home node Scripts TEAK About
RIT - P - 07009
Senior Design Project Data SheetProject # Project Name Project Track Project FamilyP07009Start TermWarfarin Automatic Home Medication DispenserTeam GuideBio-Engineering & Assistive Devices TrackProject Sponsor?Doc. Revision20062Dr. D
RIT - P - 07009
P07009 - Warfarin Automatic Home Medication Dispenser Needs Assessment Senior Design I Winter 20062 1. Easily transportable. 2. Enclosed and latched with tamper evident indicator. 3. One month supply of warfarin. 4 compartment model - 4 bulk compart
RIT - P - 07009
Customer Requirements Easily Transportable Enclosed and Latched Separate Compartments Easy and Quick Loading Clearly Labeled Pill Bins Spill Proof Programmable Interactive Interface Easy to Read Screen Visible Large Button Rapid Delivery of Dose Cons
Colorado - CSCI - 5273
CSCI 5273 Computer Networks Internetworking & Addressing Stevens 1.3-1.17Dirk Grunwald Assoc. Professor Dept. of Computer Science University of Colorado, BoulderReviewx IPq q q(Internet protocol) is designed to connect networks that arePossi
Colorado - CSCI - 5273
CSCI 5273 Computer Networks Stevens, Chapter 2 Link LayerDirk Grunwald Assoc. Professor Dept. of Computer Science University of Colorado, BoulderWhat's Coveredx Encapsulationof an IP Datagram in different link layersx Describeslink layer fo
Colorado - CSCI - 5273
CSCI 5273 Computer Networks Stevens, Chapter 3 IP: Internet Protocol Routing & SubnetsDirk Grunwald Assoc. Professor Dept. of Computer Science University of Colorado, BoulderSummary of Chapter 3x Description x Routingof IP datagram/packets form
RIT - P - 07009
Senior Design Project Roles Responsibilities MatrixName Abramo, Christopher Amin, Ntongho Columbare, Nicholas Lam, Albert Strandburg, Alan Yeung, GordonP07009: Warfarin Automatic Home Medication Dispenser Project Area of Responsibility Functional