+ Reply to Thread
Results 1 to 2 of 2

Combobox - Click row - Jump to sheet

  1. #1
    Registered User
    Join Date
    09-08-2011
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2003
    Posts
    2

    Combobox - Click row - Jump to sheet

    Hello,

    First of all I want to thank all of you that answer and resolve our problems, sometimes I'm really stuck with a problem and often I find a topic with my problem and the right answer. It's awesome...but I have another problem:

    I have a Combobox that is used to search a product database with 4 columns (Reference, Description, Quantity and Location) and I want to be able to double click a result (a row) and jump to the worksheet that has a layout of the Location.

    I have several Racks (A, B, C...) with the products, and every rack's layout is on a different worksheet with the name A, B, C, D, E, etc... And the location of the products can be B12, A102, C2 (for example, attention this is not a cell reference, it's the product's fisical location reference).

    OPTIONAL:
    It would be great if the cell with the location reference, in the correspondent layout worksheet, was selected (so it was quicker to see where the location of the product is).

    My code (part of it):

    Please Login or Register  to view this content.

    Thank you in advance...

  2. #2
    Registered User
    Join Date
    09-08-2011
    Location
    Lisbon, Portugal
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Combobox - Click row - Jump to sheet

    Any thoughts...???

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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