Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions