+ Reply to Thread
Results 1 to 5 of 5

Populate Hyperlink Data in List Box

  1. #1
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Populate Hyperlink Data in List Box

    Hi Friend,

    I have a query regards to this file:

    I have two sheet, Sheet 1 and Sheet 2

    In Sheet 1 i have a data show how many person is associated to respective department and

    In Sheet 2 i have a count of the associated person in respective department

    I hyperlink the IT, when you click on it it will show the data of Sheet 1.

    Now my requirement is :

    Whenever user click on IT, an user can see only those people in listbox1 who are associated with IT, with heading Department & Name..


    I hope you got my point..


    Regards
    Hari
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-17-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    211

    Re: Populate Hyperlink Data in List Box

    wrong topic post should have been http://www.excelforum.com/excel-prog...64#post3382664
    Last edited by hulpeloos; 08-27-2013 at 06:35 AM.
    If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.

    I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.

  3. #3
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Populate Hyperlink Data in List Box

    Hi Friend

    Thank You Very Much...

    Regards,
    Hari

  4. #4
    Forum Expert
    Join Date
    01-12-2007
    Location
    New Jersey
    Posts
    2,127

    Re: Populate Hyperlink Data in List Box

    Hari,

    There are 3 bits of code that you will need to use.

    1. In a blank module (Go to INSERT --> MODULE), enter the following line of code only:
    Please Login or Register  to view this content.
    2. In the Worksheet Event code (the code with the Hyperlink_Follow event), enter the following modification to your code:
    Please Login or Register  to view this content.
    3. Finally, in the UserForm Initialize code, enter the following code:
    Please Login or Register  to view this content.
    Does this work as required?

  5. #5
    Registered User
    Join Date
    10-10-2012
    Location
    Mumbai
    MS-Off Ver
    Excel 2003
    Posts
    51

    Re: Populate Hyperlink Data in List Box

    Hi BigBas,

    As i tried your code, but its not working.. Dear friend i want it in a this way, when i click on 22 i am getting an userform1 in which i want to show the 22 people who are associated with IT Department with there name, emp id and deparment.

    Same way for other links also....

    The way its in Sheet1..

    Hope you got it


    Regards,
    Hari
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 7
    Last Post: 06-12-2013, 07:09 PM
  2. Macro to add a hyperlink and populate data to a second workbook.
    By Hutinni in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-04-2013, 05:04 PM
  3. [SOLVED] picking data from one list to populate another
    By mustang__1 in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 08-09-2012, 01:45 PM
  4. Populate list box with excelsheet data
    By aman1234 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-10-2010, 07:41 AM
  5. [SOLVED] populate a list box with different data
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 05-12-2005, 05:06 PM

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