Add Quick Access to custom Lists. Add custom List Access to the Right-Click Menu Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
Private Sub Workbook_SheetBeforeRightClick _
(ByVal Sh As Object, ByVal Target As Range, Cancel As Boolean)

Dim cBut As CommandBarButton

Dim cControl As CommandBarControl

Dim lListCount As Long

Dim lCount As Long

Dim MyList

Dim strName As String

On Error Resume Next

With Application

'' Uncomment below to reset back to default.

' .CommandBars("Cell").Reset

For Each cControl In .CommandBars("Cell").Controls

If cControl.Caption Like "*....*" Then cControl.Delete

Next cControl

lListCount = .CustomListCount

For lCount = 1 To lListCount

MyList = .GetCustomListContents(lCount)

Set cBut = .CommandBars("Cell").Controls.Add(Temporary:=True)

With cBut

If UBound(MyList) = lListCount Then

.Caption = MyList(1) & "...." & MyList(UBound(MyList) - 1)

Else

.Caption = MyList(1) & "...." & MyList(UBound(MyList))

End If

.Style = msoButtonCaption

.OnAction = "AddFirstList"

End With

Next lCount

End With

On Error GoTo 0

End Sub

No	Macro Name
1	Add Quick Access to custom Lists. Add custom List Access to the Right-Click Menu
2	excel operators hk
3	Codes that prevent and open the vba window and access codes
4	deleting the menu bar and creating a custom menu
5	dictionary codes
6	Add menu to file edit bar delete
7	Create a user-defined menu / Create your own menu and assign a macro to them in the "Extensions" section
8	excellent menu insert file menu print print preview sheet / page structure remains
9	right mouse on active sheet / page menu
10	add time as menu (most reliable)
11	customization of toolbars remains in the file menu
12	Turkish mathematical terms
13	add time as menu
14	identifying unique (single) data entries
15	userformless form menu sheet / page select
16	Custom Header / Footer: This code is for you if you want to add a custom header. In the Run this code entry box, enter a custom value. you can edit the code to change the alignment of the header or footer.
17	add toolbars to combo box and select from there
18	add icons menus and buttons to the sheet / page
19	specifies in detail how many formulas are in the book (on new sheet / page)
20	list formulas on new sheet / page

Excel Free Macros (VBA)

Add Quick Access To Custom Lists. Add Custom List Access To The Right-click Menu

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords