Question: **This VBA must be written in excel and cannot use any built-in excel applications or loops** Write a macro to change a decimal degrees (e.g.
**This VBA must be written in excel and cannot use any built-in excel applications or loops** Write a macro to change a decimal degrees (e.g. 245.678) to degrees, minutes, seconds (e.g. 245 40' 40.8"). Input and output using message boxes and round the seconds value to one digit to the right of the decimal. Validate with a block of statements the input data to assure that the input is not less than zero or greater than 360 degrees. Place a "RUN" button on the spreadsheet. **This VBA must be written in excel and cannot use any built-in excel applications or loops**
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
