Tom’s Tutorials For Excel: Creating a Right Click Event For ActiveX Controls

by Tom Urtis 3 Comments ↓

Tom’s Tutorials For Excel: Creating a Right Click Event For ActiveX Controls

Free and safe downloadable workbook example.

There is no built-in menu for the right-click event of ActiveX objects. Here is a utility for that, using a CommandButton as an example.

‹ Tom’s Tutorials For Excel: Fuzzy Matching With Partial Strings For Sum or Average

Tom’s Tutorials For Excel: Emptying the Recycle Bin ›

Posted in Tom's Tutorials for Excel
Tags: ActiveX / Form Controls, Analytics, Big Data, Business Intelligence, Data Science, Excel Expert, Excel Guru, Macros Events Classes API, Microsoft, Microsoft Excel, Microsoft MVP, Microsoft Office, Tips and Tricks, Tom Urtis

3 comments on “Tom’s Tutorials For Excel: Creating a Right Click Event For ActiveX Controls”

1. adel says:

   August 29, 2014 at 9:18 am

   I want to learn Excel, but through detailed book

   Reply
2. Adrian Banu says:

   August 12, 2020 at 10:45 pm

   I have three macros like the one below. How to put them in Macro 1, 2, 3

   Sub Curatenie()
   Sheets(“EVIDENTA MATERIALE”).Unprotect “Password”
   ‘ moduleadrianbanu
   ‘ Curatenie Macro

   ActiveSheet.Range(“$A$9:$H$541”).AutoFilter Field:=2, Criteria1:= _
   “Curatenie”
   Sheets(“EVIDENTA MATERIALE”).Protect “Password”
   End Sub

   Reply
   • Tom Urtis says:

     August 13, 2020 at 9:22 am

     I included a downloadable workbook that shows you how. Just revise the code accordingly.

     Reply