Assign existing named table to list object in macro

**jdriscol** · 08-14-2019, 02:59 PM

Hi,

I have a data table in Excel that I'm trying to assign to a list object in a macro for the purpose of setting up some buttons to control filtering. How can I declare the table name to be a specific list object?

Thanks in advance!

**sintek** · 08-14-2019, 03:14 PM

Please Login or Register  to view this content.

**jdriscol** · 08-14-2019, 03:25 PM

Thanks for the quick response. I tried declaring the table using the following lines:

Please Login or Register  to view this content.

but I'm getting an error of Run-time error '424': Object Required. "GL" is my sheet name and "GL_Data" is my table name.

**jdriscol** · 08-14-2019, 03:29 PM

Figured it out. I guess you can't use the changed name of a sheet, but rather the actual sheet name as in "Sheet[#]" when referencing them. Thanks again for the help.

**sintek** · 08-14-2019, 03:44 PM

Glad you got it sorted...Tx for rep +

Assign existing named table to list object in macro

LinkBack

Thread Tools

Rate This Thread

Display

Assign existing named table to list object in macro

Re: Assign existing named table to list object in macro

Re: Assign existing named table to list object in macro

Re: Assign existing named table to list object in macro

Re: Assign existing named table to list object in macro

Thread Information

Users Browsing this Thread

Similar Threads

Adjust existing macro to pick up specific named worksheet and copy to named range

[SOLVED] Excel 2013: How to assign Keyboard Shortcut to existing macro?

[SOLVED] How to assign a keyboard key to existing macro?

Assign macro to an object with arguments

Assign 2 Macros to 1 Button (or Adding VBA code to the existing macro)

[SOLVED] Dynamically assign ComboBox.List from named range areas

[SOLVED] Assign a macro to Command Button Object

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions