 | |
| Excel ActiveX Combo Box to Select Worksheets with VBA |
You'll learn how to create a handy navigation combo-box for your Excel workbooks. The ActiveX combobox is automatically filled with the sheet names of your open workbook. If you add sheets, these are automatically added to the drop-down box. Deleted sheets are automatically removed from the combo-box.
You learn how to work with ActiveX controls in Excel - what "design view" is and how to adjust the properties to ActiveX controls. You also learn how to fill the values of the the drop-down on the fly so the macro is executed without the need to press a button to run it. You learn about Active X events - how to debug your VBA code and also how to tweak it so it
Related Topics:
Post a Comment