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.

Answer:-

Sub Validate_number()

Dim f_no, s_no

s_no = Range("B2")

f_no = Range("B1")

If s_no = f_no Then

MsgBox " number are equal "

ElseIf s_no < f_no Then  

MsgBox " Second number is smaller than the first number "

Else  

MsgBox "First number is smaller than the second number "

End If

End Sub

For Detailed Answer or Copy  of file

WhatsApp  at +91-91311223317

We Provide help with assignments all over the world.