Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Private Sub cmdAnswerEmployLowestSales_Click() Dim LowestEmployeeSales As String Dim LowestEmployee As String LowestEmployeeh = Application.InputBox("Enter Answer", "Lowest Employee", Type:=2) LowestEmployeeSales = WorksheetFunction.Index(Range("A3:A7"), _ WorksheetFunction.Match(WorksheetFunction.Min(Range("B3:E7")), _ Range("B3:E7"), 0)) If LowestEmployee <> LowestEmployeeSales Then MsgBox "Incorrect answer " & LowestEmployeeMonth & " does not have the lowest month sales. Try Again!" Else MsgBox "Correct Answer - great job!" End If End Sub
|Determine best-fit curve and its function [y=f(x)] from multiple (x, y) data points in Excel||6||55|
|VBA to Update status Column based on recent date||20||26|
|Some sheets won't re-calculate unless you stop and step through the code||3||12|
|Excel + % to Goal when number is negative||21||19|