Sign Up, Its Free

We have launched one more exciting feature on the site!! Now, as a Vendor apart from selling tools and templates, you can also provide hourly consultation!

Vendors who will register with us until 30.09.2020, will get the benefit of "subscription-free" registration. Vendors who are registering post 30.09.2020 might have to pay a yearly subscription fee for using our platform. So, get registered soon and spread the word.

We are launching with few Categories... However, we will be continuously multiplying our bucket list with exciting categories and sub-categories of different fields and professions!!

If you are a Vendor looking to sell tools in any specific category which is not present at the moment on our platform, for instance, say "Branding and Strategy." Simply, email us along with one of your sample business tools on "support@icrestmodels.com" and we will add the same after verifying.

We have our showcased inventory as well so that the upcoming vendors can view the quality of business tools we are looking for.

What's New

Form Controls and Other Interactive Tools in Excel

Type of Business : Excel Tools and Wizard

Price : USD 25 25.00

Need More Clarifications/Customized Tool? Generate Ticket

Add to Wishlist icrest approved product

  • Short Description

    This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form Controls. They make working with models more convenient and efficient, and the models themselves – look more professional.

  • Full Description

    This is an overview of check boxes, option buttons, drop-down lists and similar fancy things commonly referred to as Form Controls. They make working with models more convenient and efficient, and the models themselves – look more professional. The publication demonstrates what types of controls there are available and shows the differences between Form Controls and ActiveX control. Step-by-step explanations are provided on how to create controls, set them up, link to worksheet cells and apply formatting. The file gives several practical tips and formula examples. In particular, using form controls one can change some model assumptions or scenarios from any worksheet quickly. A special example of drop-down lists is the use of data validation functionality. The file also talks about dynamic hyperlinks.

  • Table of Content
    No. Content
    Introduction 1. Form Controls at a Glance 2. 'Developer' Tab
    Form Controls 1. Creating 2. Formatting
    ActiveX Controls Creation and Usage
    Linking Controls between Each Other Changing Scenarios and Inputs from any Worksheet
    Drop-Down Validation Lists 1. Static and Dynamic Source Ranges 2. Dynamic Ignoring Empty Cells
    Hyperlins Creation and Usage
  • Reviews

    No Review. Write a review and be the first.

Related Products