HA 476 Midterm Review

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

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

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 Range("myRange").Resize(2).Interior.Color = vbRed
Image of page 1

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

Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern