assignment8-2010

assignment8-2010 - ChE 263 Assignment #8 (VBA HW#3) Reading...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
ChE 263 Assignment #8 (VBA HW#3) Reading to help you do the assignment: Chapter 4 and chapter 8 of the Chapra text On all these problems, be sure to include “ Option Explicit ” at the beginning of every module. 1. (Competency 5.4; 15 points) Modify the problem 2 from the last homework answer key (ChEn Assignment #7, VBA Assignment #2) using correct variable declarations (Dim statements, option explicit). Copy over the code from the answer key posted on blackboard and add in the dim statements. 2. (Competency 5.4, 6.1, 6.2; 50 points) Create a subroutine called TempConv that will convert a temperature value in one unit to another unit. Use option buttons to allow the user to select the desired units. Insert a Command Button to run the conversion subroutine. Construct you spreadsheet to look like the figure on the following pages. Remember to use correct programming practices (Option Explicit, modular structure [functions that do the unit conversions], etc.). Note: There are hints on the following 2 pages. Make sure you look at
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

assignment8-2010 - ChE 263 Assignment #8 (VBA HW#3) Reading...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online