Class18 - Class meeting #18 Monday, Oct. 25th GEEN 1300...

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

View Full Document Right Arrow Icon
1 Class meeting #18 Monday, Oct. 25 th GEEN 1300 Introduction to Engineering Computing user interfaces o on-sheet buttons o InputBox and MsgBox functions o userforms 1 Homework #8, due Wednesday, Nov. 11 th This is a double-weighted project assignment Section Test 2, next Monday, Nov. 1 st , 7-9 p.m., different rooms MATH 100, DUAN G1B20, Sections assigned later Coverage: Classes 10-18, Labs 6-9, Text chaps 7-14 On-Sheet Buttons 1) use the Forms toolbar to place a button on the worksheet 2) assign a macro to the button 3) format the button as desired Developer tab Insert Form Controls 2
Background image of page 1

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

View Full DocumentRight Arrow Icon
2 On-Sheet Buttons draw button on worksheet and Assign Macro dialog appears automatically select macro for button and click OK 3 change button text On-Sheet Buttons change font style 4
Background image of page 2
3 On-Sheet Buttons click button to run macro use on-sheet buttons 5 for macros dedicated to the workbook and worksheet, often to launch userforms InputBox Function simplified version InputBox( “prompt”, “title”, default value ) optional typical use Xin = InputBox(“Enter value for x: “) [ assign result of InputBox to variable for later use ] complete version 6 InputBox(“prompt”,”title”,default,xpos,ypos,helpfile,context) optional
Background image of page 3

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

View Full DocumentRight Arrow Icon
4 InputBox Method (alternative to InputBox Function) object . InputBox(“prompt”,”title”, default, xpos, ypos, helpfile, context, type) optiona optional type codes 0 formula 1 number 2s t r i n g 4 logical 8 cell reference codes can be combined to allow for inputs of multiple types, e.g., 3 for number or string
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 13

Class18 - Class meeting #18 Monday, Oct. 25th GEEN 1300...

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

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