In this study, we have worksheet that it has 9 columns .
We created a VBA code
to sum the values of unique elements in column "B". Ago we listed
items in column "B" as unique elements into column "K" . Later we entered the total of these items into
We used a template that we did earlier (Filtering On Listbox And Copying Filtered Data)
in this study.
When any item of listbox clicked,another userform opens. The opened userform's text boxes are populated based on listbox clicked item value .Vba codes that supply the loading of the userform and the filling of the text boxes when double-clicking on the listbox :
Private Sub ListBox2_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
- The date can be entered to selected cell with date form.
- Text in cell can be converted easily to
- Between worksheets
of workbook can be navigated with combobox.
- Texts in the cells can be ordered as ascending /descending.
- Row height can be changed.
- Column width can be changed.
When the workbook is opened context menu is created with Workbook Activate Event :
Private Sub Workbook_Activate()
When the workbook is closed, context menu is deleted with Workbook Deactivate Event : Private Sub Workbook_Deactivate() Call DeleteFromCellMenu End Sub
If "Deactivate Event" (above code) is deleted before workbook is closed ,context menu can be used in all excel file.