+ Reply to Thread
Results 1 to 2 of 2

How to link Excel Table to ListBox using VBA

  1. #1
    Registered User
    Join Date
    12-20-2011
    Location
    cheenai
    MS-Off Ver
    Excel 2007
    Posts
    68

    How to link Excel Table to ListBox using VBA

    Hi all i am new to excel vba

    In my project i have to link excel cell name[A1-100] to List Box.

    and the corresspond value should also displayed.

    if the user selected a1 means b1 value should displayed in Listbox2.
    if the user selected a2 means b2 value should displayed in Listbox2.

    the user should edit the listbox2 value also.

    how can i do it.

  2. #2
    Forum Expert Mordred's Avatar
    Join Date
    07-06-2010
    Location
    Winnipeg, Canada
    MS-Off Ver
    2007, 2010
    Posts
    2,787

    Re: How to link Excel Table to ListBox using VBA

    Hi karthisucc9. It may be best if you upload a workbook that contains mock data with a before and after scenario of your requirements. It seems that you need a userform so I would suggest that you create one and someone here can help with the code if need be. If you do not know how to make a userform, see here for a video.
    If you're happy with someone's help, click that little star at the bottom left of their post to give them Reps.

    ---Keep on Coding in the Free World---

+ 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