Answer to Question #264502 in Visual Basic for Masego

Question

Tsegofatso Gift shop sells categorized products or items as gifts to various clients. The shop needs a VBA application that will enter all products that they sale and records them in an Excel worksheet. The owner wants to use a VBA userform for data entry.

The application must have a module and userform.

Module

On the module create the following functions and a sub: function calcVaT, function unitPrice and sub bubbleSort

• Function calcVat: this function calculates the tax charged from the selling price. It uses a parameter to receive the selling price. The tax rate is 15%

• Function unitPrice : this function calculates the actual product price before tax is added. It uses a parameter to receive the selling price.

• Sub bubbleSort : this sub receives the array of categories as a parameter and sorts it in an ascending order.

Answer 1

Dear Masego, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order