Question: Write a VBA code to convert an arbitrary binary integer number to its equivalent decimal number. Specific requirements: Use InputBox function to acquire the input
Write a VBA code to convert an arbitrary binary integer number to its equivalent decimal number. Specific requirements: Use InputBox function to acquire the input for an arbitrary binary integer number; Convert the binary integer to its equivalent decimal number; Return the decimal number in a message box. Submit your (VBA code) Excel screen shoot.
Below functions may be useful in your VBA code:
Val( ): can convert a string-type number in ( ) to its numeric value;
Len( ): can count the length or how many characters in the string in ( );
Mid( , , ) : can select and pick up certain characters from a string.
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
