Showing posts with the label VBA Excel CodeShow All

Write VBA code for a program for gym subscription plan. Allow user to enter number of months and the plan price. Assume that the user earns extra five percent discount every month. Program output is a schedule that lists each month number in gym subscription plan starting with month 1 and the user’s savings at that month.

VBA Excel Code

Example: User entered 3 months gym subscription for 120 KD plan. The outp…

Read more

Write VBA code for a program that accepts two numbers from a user and display the appropriate one of the following messages: (25%) a. First number is smaller than the second number . b. Second number < Second number> is smaller than the first number . c.Numbers are equal.

VBA Excel Code

Answer:- Sub Validate_number() Dim f_no, s_no s_no = Range("B2") f_no = Range(&…

Read more

Write VBA code for a program that accepts four values for Customer ID, Customer name, year of birth, and age from the user and displays a message if the age is incorrect. (25%) (age = 2021 - year of birth).

VBA Excel Code

Answer -  Sub Validate_age()  Dim age, yr, check As Integer  yr = Range("B3")  …

Read more