All articles with 'List Box' Tag

Show hide list boxes using VBA

Published on Dec 18, 2012 in VBA Macros
Show hide list boxes using VBA

Rama, one of our readers emailed this:
I Have Many List boxes In That I need to Hide Few Of them Using Check box

Show Hide list boxes by using a check box

We can use check box and a bit of VBA to do this easily. Something like above demo.

Read on to learn how to do this using Excel & VBA.

Continue »

Form Controls – Adding Interactivity to Your Worksheets

Published on Mar 30, 2011 in excel apps, Excel Howtos, Huis, Learn Excel, Posts by Hui
Form Controls – Adding Interactivity to Your Worksheets

Excel can be a bland collection of cells with text and numbers or it can be a playground where you can have interactive engagement with your models.

The choice is yours!

Excel provides a small number of tools to allow you to interact with your models.
These tools are called Form Controls and can be added into and linked to your models data.

This post will look at the various types of Form Controls and discuss their application and use.

Continue »