How to create DYNAMIC List boxes in Microsoft Excel

preview_player
Показать описание
In this video we will see how we can create "DYNAMIC" list boxes in Microsoft that allow us to have the options in the list box change on the fly.

We will be using a combo box, Index function, match function, and a named cell to create a DYNAMIC list box.

The Excel file used in this tutorial has been uploaded on Facebook in the Watch Learn Grow Repeat group and if you want to download the file, browse to:

If you liked this video then please hit the like button and if you would like to see more videos like this then please subscribe.
Рекомендации по теме
Комментарии
Автор

Thanks for the video. But their is a problem. Row height is fixed at 3. This breaks down when the row height varies (i.e. first quarter has 3 subsets (Jan, Feb and Mar) then second quarter has 4 (April, May, Jun, Jul)). It only show 3 because = OFFSET(B11, E11-1, 0, 3, 1) fixes it to 3 rows

femikunle