Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: vbcad
  • Content: Threads
  • Order by date
  1. vbcad

    Is this possible? I dont know where to start.

    I have a spreadsheet for some workouts. What i am trying to do is make the previous selection for each list be unavailable in the following weeks sheet. for example in Week1/Day 1 I can pick "Front Dumbbell Lateral Raise" from the list in the first section. Then on Week 2/Day 1 I would like...
  2. vbcad

    Make single item unavailable in drop down list

    I have a workbook that uses named ranges for data validation in drop down lists. For example "table1" (named range) has item 1, item 2 and item 3. this table is referenced to a drop down list in sheet 1cell a9 for example. this table is also referenced in cell a9 on sheet2 in the workbook. The...
  3. vbcad

    Good excel code. works too good

    Below is some code that works for what it was originaly intended. however all I would like to have it do now is create the list of Folders withing the main directory and only one sublevel below that. I do not need any file names just the folder names. I have attached a file to show what I would...
  4. vbcad

    Good excel code but does too much!!!

    Below is some code that works for what it was originaly intended. however all I would like to have it do now is create the list of Folders withing the main directory and only one sublevel below that. I do not need any file names just the folder names. Sub prjFiles() Workbooks.Add ' create a new...
  5. vbcad

    Lets just say I am lost!!!!!!!!! VBA to Visual Lisp

    Below is some code I am attempting to translate to visual lisp. We have upgraded to 2010 and would like to get away from the VBA editor and I can see it will eventually just go away. What it does is takes some blocks on two specific layers and changes the arcs and/or splines and changes the...
  6. vbcad

    Create a reactor lisp?

    I would like to create a reactor lisp to run the posted code. What I need to do is to rotate the attributes of all block back to zero when I use the commands "insert","Execute tool", "copy" "rotate" Basically any command that would change the orientation of the attribute. I have know idea on...
  7. vbcad

    Reactor lisp for rotating plain text in a block

    I have a reactor lisp obtained from another website, (author was not given) It works great for attributes but I am trying to figure out how to use it for plain text in a block as well. Any ideas how this can be modified to rotate the text and attributes back to zero? below is the code. (defun...
  8. vbcad

    Replace block routine.Need help with rotation

    I have a routine for replacing 4 of our blocks with 1 dynamic block. the routine works except i would like it to rotate the new block 180 degrees. This is not all my code as I have had some help from several sources. below is the code. (defun c:RJBWD (/ ENT1 BL1 NWNM OLD ODNM) ;THIS PROGRAM...
  9. vbcad

    Dynamic block replace routine. Works but need help.

    I have posted some code below. It works to do what I need it to do, however I would like to automate it further and this is where I am stuck. The code replaces a block by name and then changes the view propertie of the dynamic block. The problem I am having is that I need to select previous thru...
  10. vbcad

    Problems with cvport in routine

    Hello after struggling for a couple days I have come to the experts. I have a routine that selects a paperspace viewport and freezes and thaws layers as needed. I can select a viewport and it works fine if the viewport was created using mvsetup for example. where it fails is if the viewport was...
  11. vbcad

    why does this function repeat?

    I am new at VBA with excel so bear with me. The following code works, however it appears to run several times. I have tried in vain to resolve this issue. When I click in cell A2 the code runs several times in a row, almost like it is in a counting loop. Sub clicknow() ' module code ' clicknow...
  12. vbcad

    Control deletion of table rows?

    Is there any way to control if a row is deleted or not when a table is updated? I have a table that uses data extraction to retrieve block information. If I delete all references of a block the entire row disappears, and data that I have placed manually in the table shifts up or down based on...
  13. vbcad

    xref attachment routine

    Below is a piece of code that function fine, however i would like to make it better(of course). The code lets me select a directory to use for the current folder and the opens another dialog to prompt for the actual reference name, it them renames the xref using the "wcmatch" statement. What I...
  14. vbcad

    renaming of xref with visual lisp

    I am trying to rename an xref with lisp. I tried to use rename and the command line but you cannot use wildcards at the command line. The file would already be attached with a name of "xxxa1.dwg". what i would like to do is rename the xref "A1", so i can have multiple instances of the same...
  15. vbcad

    Folder tabs using DCL?

    Is it possible to create folder tabs similar to the "dsettings" dialog using DCL? If so what is the code format? I cant figure it out by looking at the native acad programming.
  16. vbcad

    replace block by selection routine help.

    Below is some code for a routine i copied from the autodesk website. It works fine for a single block, however what i would like to do is more complicated(of course) I would like to select multiple blocks with different names, for example on block named "fpr" and another named "dr". after the...
  17. vbcad

    routine for attaching multiple instances of xrefs

    Below is a routine for attaching xrefs. works but have one problem. With every activation of a new layout tab the open dialog appears. i would like to have the dialog apper only once and attach the same xref across the layout tabs. any help would be good. ;insert all layouts (defun...
  18. vbcad

    NEED HELP WITH SUBSRIPT OUT OF RANGE ERROR 9

    tHIS ROUTINE IS WAS WORKING AT MY OLD COMPUTER NOW IT WILL NOT. I KEEP GETTING A SUBSCRIPT OUT OF RANGE ERROR. IT WILL SELECT THE BLOCK JUST FINE BUT WHEN IT NEED TO INITILIZE THE USERFORM I GET THE ERROR 9 MESSAGE. BELOW IS THE CODE. ANY HELP I GREAT. Public acad As Object Public doc As...
  19. vbcad

    need help with attributes retrieval in VBA routine

    Belows is some code for a calculating routine. The program stops and I get Compile erro: cant find project or library. I have done a repair install Autocad 2002 and this did not help. I have noted where the routine breaks in red. any ideas would be very helpful. Public acad As Object Public doc...
  20. vbcad

    need a better find and replace command!

    I like the Autocad find and replace text command for what it does most of the time however I would like to be able to find the text and zoom in on that text no matter what layout tab it is on. For example, if I am on Layout 1 and search for the text "Room#4" Autocad tells me "this entity is on a...

Part and Inventory Search

Back
Top