If you often work in Excel with ComboBoxes from the Forms toolbar this Excel add-in can save you many hours and prevent errors.
After selecting a range of cells, contiguous or non-contiguous, you can add x number of ComboBoxes to the Worksheet in just a few clicks. All Cell Links, Names, Input Ranges and much more can be set en mass.
All ComboBoxes are added to the cells you have selected at the time of running the ComboBox Wizard. All your selected cells are shown in the All "ComboBoxes will be added to selected cell(s)" box.
You can use non-contiguous cells simply by holding down the Ctrl key (before launching the Combo Wiz) and select ranges like A1:A10, C5:C30, D5, G6:G12
The default size for all ComboBoxes added via the wizard is the same as that of the cell housing it. Clicking the "Specify Size" button will force a specified size for all ComboBoxes.
After clicking the "Specify Size" you can uncheck the "Make Same Size As Cell Housing it" Checkbox and use the "Width" and "Height" Spinbuttons to specify a size. The Preview shows you the size that will be applied.
You can also delete all specified comboboxes on the current sheet in just a few clicks.
The ComboBox Wizard does all the above and more.
It also comes with a 30 Day Money Back Guarantee and a BIG discount for an Unlimited License Version. |
