Using VBA to control Custom Lists - Excel Off The Grid

PHOTO

Sat Sep 07 2024 03:52:51 GMT+0000 (Coordinated Universal Time)

Saved by @acassell

'Add a new Custom List
Application.AddCustomList ListArray:=Array("Element1", "Element2", "Element3")

'Add a new Custom List from range of cells
Application.AddCustomList ListArray:=Range("Sheet1!A1:A3")

https://exceloffthegrid.com/vba-for-customlists-autofill-lists/

Save snippets that work from anywhere online with our extensions

Available in the Chrome Web Store

Get Firefox Add-on

Get VS Code extension

Comments

More like this

vba

@acassell

Visual Basic 6.0 Generate RSA SSH Key Visual Basic 6.0 Duplicate curl -u user:password with Chilkat HTTP Visual Basic 6.0 Stripe: Update a Customer Using VBA to control Custom Lists - Excel Off The Grid Using VBA to control Custom Lists - Excel Off The Grid How to remove Excel passwords (all 6 types) How to retrieve emails from Outlook using Excel VBA? - Stack Overflow vba - List the filenames of attachments - Stack Overflow How to export and print list of all folders and subfolders in Outlook? Rename Files Using VBA (Easy Examples) Automate Exporting all Components in an Excel Project | Experts Exchange List VBA Procedures by VBA Module and VB Procedure - Peltier Tech Parse HTML in Excel VBA - Learn by parsing hacker news home page Parse HTML in Excel VBA - Learn by parsing hacker news home page

Browse more snippets >>