Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Excel VBA Please fill in the blanks. Also I am not sure if the blanks I filled in are correct. thank you Dim Dim Dim
Excel VBA
Dim Dim Dim Dim Dim SalesPersonName nSales Sales PersonName As String nSales As Integer total Revenue As Integer amtOfSale As Integer i As Integer = InputBox("Enter salesperson name.") = InputBox("Enter the number of sales made by & = 0 To nSales InputBox("Enter the amount sold by " & = total Revenue + amtOfSale Sales PersonName &" during the week.") For amtOfSale = Sales PersonName &' on sale" & i) totalRevenue Next MsgBox Sales PersonName & " sold a total of $ & Format(total Revenue, " & "during the week.", vbinformation Please fill in the blanks. Also I am not sure if the blanks I filled in are correct. thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started