Plz help and explain Create a UserForm in Excel that calculates a logarithm of a

Question

Plz help and explain

Create a UserForm in Excel that calculates a logarithm of an argument with the given base (i.e., logbase(argument). Your "UserForm” should look something like this: Calculates logarithm of a number LOGARITHM BASE 387 RESULT 3.70217741672203 CANCEL RUN Note 1: VBA only uses “LOG', that calculates the natural logarithm of a number. For instance, LOG(4) will give you 1.38629436... Thus, in order to calculate a logarithm of a number y with the base ofx, you should remember that log.(y)-log(y)/log(x) Note 2: You know that any logarithm is only defined for positive values (i.e., >0). If you input a negative value or zero in the UserForm, the program will crash. Modify the program so that if a negative value or zero is entered, the program returns "N/A" (or "correct argument") as the result of the calculation (see below) 3 Calculates logarithm of a number LOGARITHM BASE LOGARITHM ARGUMENT 5.123 RESULT correct argument RUN CANCEL Note 3: You also know that the base must be larger than 1. If you enter a base below this limit the program will crash. Modify the program so that if a value S1 is entered as a base, the pro- gram returns "N/A" (or "correct base") as the result of the calculation (see below)

Explanation / Answer

For this we require ms-excel along with visual basic editor.To design the userform in excel first install the ms-excel along with visual basic editor.

After installation then open the ms-excel then click on the research button or F11 that opens the visual basic editor.

Then in visual basic editor click on the insert button in that click on the userform button it opens the form along with toolbox.

To design the above screens first go to the view tab in visual basic editor then change the name in properties tab.

Use the Properties window to change the name, behavior, and appearance of the form.

If we want to add textboxes then go to toolbox i.e,controls then select textboxes.

If we want to add labels agin go to toolbox i.e,controls then select label and add left side part.

If we want to add button go to toolbox then select the button and to change the name go to properties window then whatever the name you required add thet name.

Go to view tab then code option arises then you can modify the code .

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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