+ Reply to Thread
Results 1 to 13 of 13

Display description

  1. 09-22-2010, 02:31 AM #1
    SMILE
    SMILE is offline
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Display description

    Hi
    I would like to know is it possible to display the content of a cell to be displayed when i select another cell.
    Let me explain
    I have part number in col. A and the description of the part is in col Z.
    for eg if I click A5 . I should have a pop up window with the description in Z5 (like an input message in Data Validation- or like a comment display). This will make easier to know the description of my Part no than to go and check in col. Z.
    Is there any VB script for that.
    Hope my question is clear.
    Thanks for your help.
    Regds
    Toms
    Last edited by SMILE; 09-23-2010 at 01:46 AM.
    Reply With QuoteRegister To Reply
  2. 09-22-2010, 02:59 AM #2
    johnjohns
    johnjohns is offline
    Forum Contributor johnjohns's Avatar
    Join Date
    11-19-2007
    Location
    Dubai, UAE
    MS-Off Ver
    2003 and 2007
    Posts
    526

    Re: Display description

    Copy the area and paste as link (pressing Shift key and using edit options). See the attachment and change cell M6's content. No macro required


    rgds

    johnjohns
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  3. 09-22-2010, 03:55 AM #3
    asha3010
    asha3010 is offline
    Forum Contributor
    Join Date
    02-09-2010
    Location
    Constanta
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Display description

    Hello Smile,

    If your goal is to avoid scrolling all the way to Column Z, you could also try splitting the window or freezing the panes.

    However if you prefer a display box, you could try this code. Attached is a sample file. 

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  4. 09-22-2010, 04:15 AM #4
    snb
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Display description

    You can make use of comments.
    Add a comment to all cells you want to display something.

    Assuming the combination of parts and part properties is stored in columns 26 (parts) and columns 27 (properties) use this macro to keep the comment up to date:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by snb; 09-22-2010 at 04:19 AM.

    Reply With QuoteRegister To Reply
  5. 09-22-2010, 04:20 AM #5
    SMILE
    SMILE is offline
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Re: Display description

    Thanks everyone for the suggessions... its wonderful!!!! I got what i wanted.. Thanks again guys!!!
    Reply With QuoteRegister To Reply
  6. 09-22-2010, 04:33 AM #6
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Display description

    If you are satisfied with the solution(s) provided, please mark your thread as Solved.

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save
    Hope that helps.

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

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
  7. 09-22-2010, 06:22 AM #7
    SMILE
    SMILE is offline
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Re: Display description

    Asha3010
    Your codes are working perfect.
    Now, how can I copy the codes into another file. Sorry I am not an expert.
    I copy the entire code into another file but I am getting error while entering any data in it. "Run time error 1004"Method 'Range' of object'_Worksheet' failed.
    can u give me some clue . It seems there are some hidden things in it like "Test". I didn't understand the use of that. Sorry if I bother you people.
    Thanks


    Quote Originally Posted by asha3010 View Post
    Hello Smile,

    If your goal is to avoid scrolling all the way to Column Z, you could also try splitting the window or freezing the panes.

    However if you prefer a display box, you could try this code. Attached is a sample file. 

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 09-22-2010, 06:33 AM #8
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Display description

    Where have you pasted the code? It's worksheet event code, so


    Copy the code
    Select the worksheet in which you the code to run
    Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
    Where the cursor is flashing, choose Edit | Paste
    Reply With QuoteRegister To Reply
  9. 09-22-2010, 06:40 AM #9
    asha3010
    asha3010 is offline
    Forum Contributor
    Join Date
    02-09-2010
    Location
    Constanta
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Display description

    Hi Smile,

    If you are having a problem even after royUK's solution, post your sample file.

    Asha
    Reply With QuoteRegister To Reply
  10. 09-22-2010, 06:44 AM #10
    SMILE
    SMILE is offline
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Re: Display description

    Yes I did copy the same way. But when i am entering any data in my excel sheet, it gives that error.

    Quote Originally Posted by royUK View Post
    Where have you pasted the code? It's worksheet event code, so


    Copy the code
    Select the worksheet in which you the code to run
    Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
    Where the cursor is flashing, choose Edit | Paste
    Reply With QuoteRegister To Reply
  11. 09-22-2010, 06:51 AM #11
    SMILE
    SMILE is offline
    Forum Contributor
    Join Date
    01-14-2004
    Location
    India
    MS-Off Ver
    365
    Posts
    264

    Re: Display description

    Asha
    I am attaching my file. please let me know where I am wrong.. Thanks for your patience.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  12. 09-22-2010, 07:08 AM #12
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200

    Re: Display description

    You don't have the named range "Test" in this workbook
    Reply With QuoteRegister To Reply
  13. 09-22-2010, 07:12 AM #13
    asha3010
    asha3010 is offline
    Forum Contributor
    Join Date
    02-09-2010
    Location
    Constanta
    MS-Off Ver
    Excel 2007
    Posts
    128

    Re: Display description

    Glad to be of help as I have got so much from this forum.

    "Test" is a dynamic named range. If you are using XL2007, goto Formulas -> Name Manager -> Click on "Test" to see what it refers to.

    In the file you posted, "Test" was not defined hence the error. You can also substitute "Test" with the range reference, eg "A1:A100" and the code will work.

    Hopefully this will resolve your issue.
    Asha

    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1