fbpx
Search
Close this search box.

CP005: Introduction to Form Controls – an interview with Debra Dalgleish

Share

Facebook
Twitter
LinkedIn

In the 5th session of Chandoo.org podcast, we are going to demystify form controls.

I am very happy and excited to interview my good friend, fellow Excel MVP, author, blogger and virtual mentor – Debra Dalgleish about this topic.

CP005: Introduction to Form controls - an interview with Debra Dalgleish

Before we proceed in to the session, let me remind you:

Get new episodes automatically!

That is right. Chandoo.org uses latest & most magical software. That means, whenever a podcast goes live, an army of magical fairies carry the sound-waves and bring them right to your mobile phone or tablet. And all you have to do is subscribe.

What is in this session?

In this session we are going to explore form controls, a powerful feature of Excel that makes your workbooks interactive. Debra is a world famous expert on all topics of Excel (especially data validation, pivot tables & form controls) and this session is very entertaining, informative and practical.

Special gift for our listeners:
In this podcast Debra mentions about her User forms training kit. I highly recommend this product for anyone hoping to learn user forms, data entry forms and form controls. As our podcast listener, if you choose to purchase this training kit, you get

  • 20% discount on Debra’s User Form Training kit (if you buy before April 30th, 2014)
  • Special bonus from me: 14 page guide & practice workbook on form controls

Listen to the podcast to know how to get these.

In this podcast, you will learn,

  • What are form controls
  • When you would use them?
  • Example form control – Combo box
  • How form controls differ from active-x controls
  • How to enable form controls in your Excel?
  • Various important form controls
    • Combo box
    • Command Button
    • Radio Button
    • Check box
    • Scroll bar & Spin button
    • List box
  • Compatibility of form controls between various version of Excel
  • Comparison of form controls with other types of interactive features in Excel
    • Slicers
    • Hyper links
    • VBA
  • Debra’s favorite form control tip
  • Special bonus & how to obtain it

Go ahead and listen to the show

Links & Resources mentioned in this session:

Debra’s website – Contextures.com

Books mentioned:

Courses mentioned:

Articles & Discussion on Form controls

Other types of interactive features in Excel

Recommended Resource – Debra’s User Form Training Kit

If you wish to learn more about user forms, form controls and how they can simplify life for your workbook users, then please consider purchasing Debra’s User Form training kit. It is an eBook + Excel workbook combo that works very well and helps you understand these advanced concepts very easily.

Click here to get your copy.

Note: You get 20% discount on this if you buy before 30th of April. Listen to podcast for details.

Note about links: The links to various books & Debra’s training kit are affiliate links. It means when you click on them & purchase, Chandoo.org receives some commission. I recommend these books because I genuinely love them. I would have recommended even if there is no benefit to me.

Transcript of this session:

Download this podcast transcript [PDF]

If you enjoy the podcast…,

Please do these 2 things. It means a lot me & our community.

  1. Subscribe to our podcast on iTunes
  2. Please leave an honest review on iTunes by clicking here.. It will help the show & its rankings immensely. Thank you so much.

Do you use form controls?

I use them in almost all my dashboards. They are really easy to set up and use. I also love slicers, hyperlinks, little bit of VBA and any other type of interactive features Excel supports.

What about you? Do you use form controls? What is your experience like? Please share using comments.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Excel School made me great at work.
5/5

– Brenda

Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

Weighted Average in Excel with Percentage Weights

Weighted Average in Excel [Formulas]

Learn how to calculate weighted averages in excel using formulas. In this article we will learn what a weighted average is and how to Excel’s SUMPRODUCT formula to calculate weighted average / weighted mean.

What is weighted average?

Wikipedia defines weighted average as, “The weighted mean is similar to an arithmetic mean …, where instead of each of the data points contributing equally to the final average, some data points contribute more than others.”

Calculating weighted averages in excel is not straight forward as there is no built-in formula. But we can use SUMPRODUCT formula to easily calculate them. Read on to find out how.

8 Responses to “CP005: Introduction to Form Controls – an interview with Debra Dalgleish”

  1. […] for a friendly, and informative, discussion. And you'll be able to hear what we said -- Chandoo has posted a recording in the next episode of his Excel […]

  2. Samtheman says:

    Hi!
    I listened your podcast. Thanks a lot to you and Debra Dalgleish for bringing us such a good podcast.
    I purchased Debra’s User Form Training kit via your discount code.
    I got everything except the "14 page guide & practice workbook on form controls" from you. Could you please help how to get your bonus guide & practice workbook.

  3. Oz du Soleil says:

    Excellent interview! And thanks so much for being so detailed about ActiveX controls. Some people treat ActiveX like it's a disease. From your discussion I get that you just have to pick your spots while being aware of the weaknesses.

  4. Pablo says:

    Hi Chandoo,
    Very good interview and content. Exactly how a podcast should be. Keep up the interviews formats!
    The only suggestion that I have is split it in 2 parts of 30 minutes or so each.
    Reasons:
    - Easier for the public to find the time to list to it.
    - You spend a lot of time an energy to prepare for the podcast, so you can use the content for 2 sessions instead of 1. It buys you more time to prepare for the next podcast.
    Thanks,
    Pablo

    • Khushnood Viccaji says:

      I agree with Pablo... excellent interview, but too long to listen to it in one go.
      I finally decided to sit up late in the night and listen to it without a break 🙂

      A split interview of 2 or 3 parts would be much better for the listeners as well as for the 'podcaster' 🙂

  5. Simon Hughes says:

    Hello, I have just bought the form controls kit but did not get the “14 page guide & practice workbook on form controls”. Could this be emailed to me? Many thanks

    Simon

  6. Tom Jones says:

    Hi,
    We have just found your site and purchased your book, we would like to purchase Debras book, has the offer been extended to now for us to also get 20% discount and the 14 page guide & practice workbook on form controls” from you, if you could let us know as soon as possible.
    an 89 page written lesson guide (PDF format), with video tutorials and demos
    2 step by step projects, and completed workbooks, and starting files
    5 bonus workbooks with advanced UserForm samples
    User Guide and demo videos for the bonus files

    20% discount on Debra’s User Form Training kit (if you buy before April 30th, 2014)

    Best regards

    Tom Jones

Leave a Reply