Interfaces_Take2

Interfaces_Take2 - Graphic User Interfaces#2 CEE3804...

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

View Full Document Right Arrow Icon
01/02/12 Copyright 2007 1 Graphic User Interfaces (#2) CEE3804: Computer Applications for Civil and Environmental Engineers
Background image of page 1

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

View Full DocumentRight Arrow Icon
01/02/12 Copyright 2007 2 Objectives Understand the principles of GUIs and data validation and data entry Use VBA to promote such understanding Provide with some examples
Background image of page 2
01/02/12 Copyright 2007 3 Previous Example (kicker_with_angleTable_2003.xls) Kicker program with “Run” button assigned to a macro
Background image of page 3

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

View Full DocumentRight Arrow Icon
01/02/12 Copyright 2007 4 Suppose We Add a New Control Lets add a slider control to set the values of initial angle and initial speed Procedure: Go to the “Developer” tab in Excel 2007 Go to the “View” toolbox (then forms) in Excel 2003
Background image of page 4
01/02/12 Copyright 2007 5 Adding a New Control (Form Control) Check all controls available and add a simple scrollbar control to the “kicker” spreadsheet
Background image of page 5

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

View Full DocumentRight Arrow Icon
01/02/12 Copyright 2007 6 VBA Control Example The Control is linked to a cell in your spreadsheet Control (scrollbar) Control Parameters
Background image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 01/01/2012 for the course CEE 3804 taught by Professor Aatrani during the Spring '07 term at Virginia Tech.

Page1 / 14

Interfaces_Take2 - Graphic User Interfaces#2 CEE3804...

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

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