In it, there is a fixed array, populated with all the options. Here, the routine dedicated to the ComboBox is coded to the Change event by default. Private Sub Worksheet_SelectionChange(ByVal Target As Range) In this case, every time you activate a cell, the code is redirected to the Combo Box's code. You can select "Worksheet" from the first drop-down menu above the code window, and "Selection_Change" from the drop down menu next to it. This is the Worksheet_SelectionChange event, which fires each time a different cell is selected in the active sheet. In general, the code is placed in the module of a sheet. You'll be able to insert one of five Jimi Hendrix songs in any activated cell of the sheet and be able to clear it, accordingly. This is a simple example demonstrating how to create a drop down menu in the Active Sheet of your workbook by inserting a Combo Box Activex object in the sheet.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |