Question

Insert a spin button and scroll bar in the Outsourcing Decision model to allow the user to easily change the production volume in Cell B12 from 500 to 3000. Which one is easier to use? Discuss the Pros and cons of each.

Answer 1

Firstly one should know about form controls and Active-x controls.

Elements before excel 2007 only form controls are there, and active-x controls introduced after excel 2007. These spin button and scroll bar are comes under in Active-x form controls.

Spin button and scroll bar are easy to use. Beacuse it gives more flexibility to use. Moving model will be fast using scroll bars.

Now discuss about pros & cons:

Advantages of ActiveX controls:
------------------------------------
They provide lots of options which can be used to developer to perform more operations.
They posses lot of action events.
Controlling over form control via VBA programming is very easy.
Formatting options are more like size, shape..
When event fires, then it returns index value and index number so UI manipulation is esy.
Scroll bars helps to jump to any cell easily.

Disadvantages:
---------------
Using macros is cumbersome.
Beacuse of this rich form controls, file corruptions may occur.
For mobile and tab users, horizontal scroll is not good and developers won't encourge horizontal scroll.