Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Open the JobsEntry form in Design View and complete the following: Open the Visual Basic Editor window for the form. Insert the comment 'Highlights jobs
Open the JobsEntry form in Design View and complete the following: Open the Visual Basic Editor window for the form. Insert the comment 'Highlights jobs in the energy industry as a new second line in the procedure just above the If statement. Save and close the Visual Basic Editor window then save and close the JobsEntry form. Create a standard module and save it using CustomFunctions as the name, and then create a new function within it by entering the code shown below, which is also shown in Figure 3. Function Demand(SalaryValue, IndustryValue) If SalaryValue > 50000 Then Demand = 3 ElseIf SalaryValue > 60000 Or IndustryValue = "Energy" Then Demand = 4 ElseIf SalaryValue > 60000 And IndustryValue = "Energy" Then Demand = 5 End If End Function Save and close the CustomFunctions module
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