CAD Forum - Database of tips, tricks and utilities for AutoCAD, Inventor and other Autodesk products []
Czech English Deutsch
 Visitors: 1528 
RSS tips RSS channel - CAD tips
RSS discussion RSS channel - CAD discussion

Discussion Discussion forum

HelpCAD discussion

CAD Forum - Homepage CAD discussion forum - ask any CAD-related questions here, share your CAD knowledge on AutoCAD, Inventor, Revit and other Autodesk software with your peers from all over the world. To start a new topic, choose an appropriate forum.

Please abide by the rules of this forum.

How to post questions: register or login, go to the specific forum and click the NEW TOPIC button.
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

The information that you provide in this form will make up your forum profile which can be viewed by other forum members. Your email address will only be visible by forum admin and moderators and will be used to send you Forum Notifications. To cancel your account, use the page Opt-out or contact

Block Attribute with Lookup to Extract to Excel

 Post Reply Post Reply
Mark_Duffy View Drop Down

Joined: 11.Jul.2012
Location: United Kingdom
Using: AutoCad 2010
Status: Offline
Points: 5
Post Options Post Options   Thanks (0) Thanks(0)   Quote Mark_Duffy Quote  Post ReplyReply Direct Link To This Post Topic: Block Attribute with Lookup to Extract to Excel
    Posted: 02.Aug.2019 at 12:06

Good day to you all.

I am trying to find a way to have a drop-down lookup attached to an attribute in a block.

Electric switch, Type: one gang, Two gang, Three gang … etc


Room: Living room, Kitchen, Bathroom… etc 

I can type these in as a type of room name in the Edit Attributes box but spelling mistakes or extra space / full stop will mean that it is in a separate column when Extract Data is performed. A drop down will avoid this. There are a number of instances with a switch where there are different options. So this would be a really useful ability for me and I’m hoping others. I have used look up with the stretch state on Linear for doors and windows and  

I have thought of having and invisible numbers which can be chosen but haven’t got my head around that yet and visibility states do not extract.

Here’s Trilled to look forward to getting a solution.

All the best


Back to Top

Related CAD tips:

 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

This page was generated in 0,047 seconds.