Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
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
|Move data from one sheet to another||11||28|
|Data in Rows to be converted into single row||9||39|
|Excel 2010 - Selecting and copying cells from areas with hidden rows is not working||3||19|
|Excel format formula for currency||15||22|