Announcements
Attention for Customers without Multi-Factor Authentication or Single Sign-On - OTP Verification rolls out April 2025. Read all about it here.
AMN3161
424 Views, 2 Replies

VB Look up by Table Name

Is there a way to specify the table in a sheet you want to do the VB look up to? (see attached)

 

That table a few rows down has a table name as BOM but a VB look cannot find the columns because the table is not at the top of the screen. In excel VB look up you can specify a table name so excel will just find that table on a specific sheet and use that rather needing the table at the top of the workbook.

 

I posted this a few days ago but after speaking to the engineer we really dont want to have to change our BOM templates for the excel documents.

Did you ever figure this out. Ive been looking for the same solution.

Can you explain a little more of your requirement? The initial post doesn't have an object like a BOM/Partlist for exporting data or any source code involved. 

If this solved a problem, please click (accept) as solution.‌‌‌‌
Or if this helped you, please, click (like)‌‌
Regards
Alan