Question: Write a VBA code to convert an arbitrary binary INTEGER number to equivalent decimal number. Specific requirements: Use Input Box function to request the input
Write a VBA code to convert an arbitrary binary INTEGER number to equivalent decimal number. Specific requirements: Use Input Box function to request the input for an arbitrary binary number: Convert the binary number to equivalent decimal integer number: Return the decimal number in a message box. Submit your Excel file via Moodle. Below functions may be useful in your VBA code if you input binary number as string: Cstr(): can convert a number in () to a string Len(): count the length of the string in () b Val(): can convert a string number in () to numerical number Mid(xxx, x, x): can pick up one or more characters from the string variable in () starting from the left end of the string
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
