1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Daniel [21]
3 years ago
9

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 us

ing 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.

Computers and Technology
1 answer:
Brut [27]3 years ago
4 0

Answer:

All the procedure is explained below step-by-step

  1. Press alt+F11 to open VBA in excel.
  2. Create a module and start entering the subroutine.
  3. The coding of subroutine is attached in the image.

For adding "RUN" button:

  1. Select a shape on the sheet for the button.(Insert > Shapes > Rectangle).
  2. Double click on the shape to add text and write "RUN".
  3. The button can be styled by adding colors and shadows.
  4. Now Assign macro to the button (Right click  > Assign macro).
  5. A window pane will appear, select the macro from This workbook list so that it may work properly when shared with others.
  6. Press OK.
  7. "RUN" button has been created and by pressing it the subroutine will work as required.

You might be interested in
If the system has a mechanical advantage of 5 and the load of 350N.What effort is needed to lift the weight? Provide your answer
FromTheMoon [43]

Answer:

Effort = 70 N

Explanation:

A machine is a device that can be used to overcome a load by the application of a minimal effort. For a practical machine, mechanical advantage (MA) is the ratio of the load (L) overcome to the effort (E) applied.

i.e MA = \frac{Load}{Effort}

In the given question, MA = 5 and the load = 350 N. So that;

5 = \frac{350}{E}

E = \frac{350}{5}

  = 70

The effort applied to the machine is 70 N.

3 0
3 years ago
The "offset" between the viewfinder and the lens in compact cameras results in a problem called
boyakko [2]
The answer is Parallax.

5 0
4 years ago
When do you use an else statement for coding
tankabanditka [31]

Answer:

to check to see if some expression is true, and if it is do something, otherwise do something else. An if/else statement requires you to define an expression that evaluates to true or false.

Explanation:

4 0
3 years ago
Define file manager
Mama L [17]

Answer:

A file manager or file browser is a computer program that provides a user interface to manage files and folders.

3 0
3 years ago
I DON"T GET THIS WHY IS THIS FUNNY
MakcuM [25]

Answer:

They deleted my answer what is funny?

Explanation:

8 0
3 years ago
Other questions:
  • Which type of peripheral is a keyboard?
    11·2 answers
  • What is C.R.A.T systems used for?
    9·1 answer
  • Suppose that a computer can read or write a memory word in 5 nsec. Also suppose that when an interrupt occurs, all 32 CPU regist
    10·2 answers
  • A user who enters americanbank.net into a web browser instead of the correct americanbank and is then taken to a fake look-alike
    11·2 answers
  • What is the Piston Displacement having 3-inch bore and 3-inch stroke?
    11·1 answer
  • Need help asap
    5·1 answer
  • Only need help on f and correct me if im wrong for the other questions please
    11·1 answer
  • The _____ of a story describes the time and location of a story.
    5·2 answers
  • A _____ is a grid that displays fields as columns and records as rows.
    12·1 answer
  • HURRY GANG 100points!!!! How can you determine which hardware brands and models are the most reliable?
    7·2 answers
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!