HA 476 Midterm Review

HA 476 Midterm Review - HA 476 Midterm Review Key Objects:...

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

View Full Document Right Arrow Icon
HA 476 Midterm Review Key Objects : ThisWorkBook!!!!!!!1 Application o SendKeys (imitates keystrokes) o DisplayAlerts = True, False (ignores warning boxes) o ActiveCell: property o GetOpenFileName (opens browse files and gets name, but doesn’t open) o Caption (can set properties: ie. = “new caption”) o Range: is a property here, so can’t set container of “A1” to another range, unless use an additional property (.value) o ThisWorkbook vs. ActiveWorkbook o Intersect method o Union method o onTime method ActiveWindow o Zoom Selection ThisWorkbook o ProcessingEvent ActiveCell o Interior.Color (rgbColor) CommandBars o These methods all take argument idMso o GetEnabledMso o ExecuteMso o GetImageMso o GetLabelMso o GetPressedMso Strings o inStr([start], searchable string, string looking for, [compare]) o LCase method ActiveWindow o DisplayWorkbookTabs (True, False) Range o Rows.EntireRow o Resize method: creates new range of specified dimensions
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.

This note was uploaded on 04/01/2008 for the course H ADM 476 taught by Professor Mtalbert during the Spring '08 term at Cornell.

Page1 / 4

HA 476 Midterm Review - HA 476 Midterm Review Key Objects:...

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