Question: Using a UserForm in VBA write a code.The UserForm has 4 option button.Each one has a specific function: I. Using column D find all items

 Using a UserForm in VBA write a code.The UserForm has 4

Using a UserForm in VBA write a code.The UserForm has 4 option button.Each one has a specific function: I. Using column D find all items that have a 7% discount 2.Using column A find all products wich code start with letter E 3.Using column B find all products whose price is from $50 to $100 4.Using column C, find values from 5 to 20 Every step needs to be done every time you select their option button and press calculate.For example If you select option 1 you need to press the calculate button for the results to show in the UserForm. The reset button needs to reset the list.THE CODE NEEDS LOOP INSTRUCTIONS

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!