Question
Two very convenient mechanisms for control tasks in Excel are: Scroll Bar (Form Control) and Button (Form Control). These can be made available in the
Two very convenient mechanisms for control tasks in Excel are: Scroll Bar (Form Control) and Button (Form Control). These can be made available in the Quick Access Toolbar by using the steps--File/Options/Quick Access Toolbar/All Commands/Add. The also appear in the Developer ribbon under Controls/Insert/Forms Control.
Use the Buttons to do the following in EXCEL:
1) Assign a manually recorded macro to a Button called "Take Me Home," that when pressed activates a hyperlink to http://mason.wm.edu/ .
2) Assign a manually recorded macro to a Button called "You Move Me" that when activated does the following: copies that data range below and moves it over by 3 columns and pastes it, sorts the entire data set by value (small to large), then finally, the cursor is returned to the Cell A1.
Obs | Value |
1 | 25 |
2 | 34 |
3 | 92 |
4 | 129 |
5 | 76 |
6 | 31 |
3) Create a scroll bar that generates values from 3% to 15% in exactly 0.5% increments--3%, 3.5%, etc.
PLEASE EXPLAIN STEP BY STEP HOW TO COMPLETE ALL TASKS. THANK YOU!
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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