FINAL RESULT SHOULD LOOK LIKE BELOW PICTURE: I NEED IN VBA EXCEL. VBA EXCEL. VBA

Question

FINAL RESULT SHOULD LOOK LIKE BELOW PICTURE:

I NEED IN VBA EXCEL. VBA EXCEL. VBA EXCEL. VBA EXCEL MULTIFORM

Link to the data:

https://docs.google.com/spreadsheets/d/1VQBeokg91Hje6DHZRLwfXBfr6BpxYbJJ7y9bfpoNs1w/edit?usp=sharing

***PLEASE GUIDE ME STEP TO STEP HOW TO CREATE THIS (CREATE FORMS AND CODE FOR SUBS AND BUTTONS). SHOW ME HOW ITS DONE AND ILL RECREATE IT***

Using only VBA in excel, create a multipage user form that Question 2. The Q2 - Exceptions worksheet contains monthly sales totals for a number of sales regions. Create a multipage user form that uses a button that will be located below the data to open the Exceptions page of a MultiPa e User Form to access a User Form like the example shown (pictures below at the end). Use vbRed or Red, vbBlue for Blue and vbGreen for Green in your code. Basically this solution will allow you to choose one of three colors for the low values it the table, one of three for the high values in the table and will apply these rules when the OK button is clicked (Please pay attention to the Multipage number found in the dropdown list to the left of the code window to find the order number of the pages in your MultiPage UserForm. The first one will be page number 0 in the order, the second will be 1, etc. so, if you have attempted to create the Multipage UserForm more than once, the first multipage listed might be MultiPage3. To insure that you have the correct multipage showing when you open the UserForm, have command similar to this: UserForm1.MultiPage3.Value 1. This assumes that the Exceptions page is the second page in your Multipage UserForm

Explanation / Answer

Step 1:-

1. Open the Visual Basic Editor. If the Project Explorer is not visible, click View, Project Explorer.

2. Click Insert, Userform.

3. Add the Multipage control, labels, text boxes (first at the top, the second below the first), frame, option buttons (first at the left, the second at the right),

Step Design the forms using the controls.

Step After adding each control, the controls have to be named. Caption corresponds to what appears on the form and name corresponds to the logical name that will be appearing when you write VBA code for that element.

Step Add the code for the form load event by performing a right-click on the form and selecting 'View Code'.

Step Select ‘Userform’ from the objects drop-down and select 'Initialize' method as shown in the following screenshot.

Step Upon Loading the form, ensure that the text boxes are cleared,

Here the code for initialize the form:-->

End sub

Step Now add the code to the Submit button. Upon clicking the submit button, the user should be able to add the values into the worksheet.

Give the button macro name showValue_Click

Click on edit button

'here write the code for change the color of text according value'

End sub

Draw the command button anywhere on the worksheet

You will get the dialogue window

End sub

Step Execute the form by clicking the "Run" button. Enter the values into the form and click the 'Submit' button. Automatically the values will flow into the worksheet

Step -

To insert a Module, navigate to Insert Module. Once a module is inserted 'module1' is created.

Within the modules, we can write VBA code and the code is written within a Procedure. A Procedure/Sub Procedure is a series of VBA statements instructing what to do.

Here we are going to write a method to choose vbRed for red vbBlue for Blue vbGreen for green.

Related Questions

Navigate

• Browse (All)
• Browse F
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.