Question
use VBA 11. Numbers in Alphabetical Order 1) Name a sheet NumberOrder. 2) Create a function called NumberOrder that accepts 2 numbers as inputs. Check
use VBA
11. Numbers in Alphabetical Order 1) Name a sheet NumberOrder. 2) Create a function called "NumberOrder" that accepts 2 numbers as inputs. Check to see which one is larger in alphabetical order. To do this, compare the first digits in each number. If one is larger, then you know the larger number. If they are the same, move on to the next digit and test again. Repeat until you know which is larger (alphabetically) or you find them to be the same. 123 is less than 1234 in this setting, just like fishy comes after fish. 3) If either value is non-numeric the output should be "One or more values is non-numeric." 4) If the input numbers are A and B, then the outputs should be "A>B" Or "B>A" or "A and B are the same."
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started