+ Reply to Thread
Results 1 to 2 of 2

Naming Objects/Recalling via vlookup,etc

  1. #1
    Registered User
    Join Date
    05-17-2005
    Location
    Chicago, IL
    Posts
    16

    Naming Objects/Recalling via vlookup,etc

    Hello all-

    I am working on an estimating program for my job and often use simple diagrams to explain things (steel components , etc.).. I'd like to be able to draw a picture of say, a sample bolt (say on another excel sheet) and somehow name this drawing bolt1 or something. Then when some picks this particular bolt from a combo box on the master sheet,have some sort of formula or macro that will find the object I've associated with the the combo box control and cause it to come up on the master sheet in a designated area.

    Does this make sense? ANy suggestions?

    -Thanks TJ

  2. #2
    Registered User
    Join Date
    05-17-2005
    Location
    Chicago, IL
    Posts
    16

    Still seeking some guidance

    Would be be possible to name a link to my object, use a vlookup to bring that link up and write some sort of macro that will select the link, and bring up the "named" object?? Or a macro that would do all of that?

+ 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