Wednesday, August 10, 2016

Excel Vba Context (Right-Click) Menu

Creating Popup Menu in All Versions of Excel 

With the context menu that created by the macro:

- The date can be entered to selected cell with date form.

- Text in cell can be converted easily to uppercase-lowercase-propercase

-  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()
    Call AddToCellMenu
End Sub

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.

No comments:

Post a Comment