prof-rossetti / intro-to-vba

An Intro to Programming in VBA (Computer-based Decision Support Systems - Spring 2019)

OPIM 557: Computer-based Decision Support Systems

University	Georgetown University
School	McDonough School of Business
Department	Operations and Information Management (OPIM)
Course	Computer-based Decision Support Systems (557)
Term	Spring 2019, Module 4
Credits	1.5

This course explores advanced topics in management support systems with a focus on decision theory. The course will present insights into key issues and problems in decision support information systems. The Visual Basic for Applications (VBA) programming language within MS Excel will be used as the primary tool to build basic decision support systems. Class deliverables will be systems built with VBA code.

Bookmark-worthy Links:

• Syllabus
• Canvas
• Slack, Onboarding Guide
• Troubleshooting Guide

Instructional Units:

• Unit 1 - Intro to Object-oriented Programming
• Unit 2 - User Interfaces and Experiences (UI/UX)
• Unit 3 - System Maintenance and Quality Control
• Unit 4 - Financial Modeling
• Unit 5 - Data-driven Decision-making
• Unit 6 - Integrated Systems

License

intro-to-vba's Issues

Borders

• https://docs.microsoft.com/en-us/office/vba/api/excel.range.borders
• https://docs.microsoft.com/en-us/office/vba/api/excel.borders
• https://docs.microsoft.com/en-us/office/vba/api/excel.xlbordersindex
• https://docs.microsoft.com/en-us/dotnet/api/microsoft.office.interop.excel.border.linestyle

Sheets("Data").Range("D6").Borders.LineStyle = xlContinuous
Sheets("Data").Range("D6").Borders.LineStyle = xlLineStyleNone

Dates

It would be nice to provide links to documentation and examples for how to work with Date datatypes, including in conjunction with the Format() function.

See:

• https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/date-data-type
• https://docs.microsoft.com/en-us/office/vba/language/reference/user-interface-help/format-function-visual-basic-for-applications#example

Format(Now(), "yyyy-mm-dd")

' documentation examples:

Dim MyTime, MyDate, MyStr
MyTime = #17:04:23#
MyDate = #January 27, 1993#

' Returns current system time in the system-defined long time format.
MyStr = Format(Time, "Long Time")

' Returns current system date in the system-defined long date format.
MyStr = Format(Date, "Long Date")

MyStr = Format(MyTime, "h:m:s")    ' Returns "17:4:23".
MyStr = Format(MyTime, "hh:mm:ss am/pm")    ' Returns "05:04:23 pm".
MyStr = Format(MyTime, "hh:mm:ss AM/PM")    ' Returns "05:04:23 PM".
MyStr = Format(MyDate, "dddd, mmm d yyyy")    ' Returns "Wednesday, Jan 27 1993".
' If format is not supplied, a string is returned.
MyStr = Format(23)    ' Returns "23".

Screenshots

Posting code here for screenshotting and inclusion in slides