+ Reply to Thread
Results 1 to 4 of 4

ComboBoxes & Autodesk Inveentor

  1. #1
    Registered User
    Join Date
    03-09-2004
    Location
    Michigan
    Posts
    13

    ComboBoxes & Autodesk Inveentor

    Hi to all,

    Big problems with small programming

    In worksheet I got (3) sheets: Inventor, Main & Data
    all info is on Data
    on Main - a few ComboBoxes from Control Toolbox
    on Data definition of a few named lists
    Coding:

    Please Login or Register  to view this content.
    Same idea for another combo.
    All works OK.
    Now main problem:
    worksheet in inside Autodest Inventor iAssembly
    if I save & close drawing, then try to open again
    I got an error:
    Select Case Sheets("Data").Range("n30") - not supported
    debug disply this line yellow.
    If I program combos w/out vba - all is ok
    I hope this code needs a simple modification

    Thanks for any help/ideas..
    Ursus Uziemblo
    Last edited by rylo; 05-23-2008 at 09:34 PM.

  2. #2
    Registered User
    Join Date
    03-09-2004
    Location
    Michigan
    Posts
    13
    attached is png of error message
    Ursus Uziemblo
    Attached Images Attached Images

  3. #3
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    Presumably Digit_6 is a Named Range. Try this

    Please Login or Register  to view this content.
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  4. #4
    Registered User
    Join Date
    03-09-2004
    Location
    Michigan
    Posts
    13
    Thanks Roy,

    error is on sheets method (see png)
    named range is part of workbook (not worksheet)
    Sheets("Data").Range("Listname") returns an error.
    My intuition push me in direction of declaring named "aaa"
    dim aaa as (????) - but no clue how to
    Thanks again
    Ursus Uziemblo

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1