+ Reply to Thread
Results 1 to 3 of 3

User Form List items to link to other sheets in the workbook

  1. #1
    Registered User
    Join Date
    07-16-2010
    Location
    CO
    MS-Off Ver
    Excel 2003
    Posts
    18

    User Form List items to link to other sheets in the workbook

    Hello

    I was wondering it was possible to link a list item in a list box (list box is in a user form) to a worksheet within the book. any help would be great! thanks!

  2. #2
    Registered User
    Join Date
    07-29-2010
    Location
    Chicago
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: User Form List items to link to other sheets in the workbook

    You can set the RowSource property of the Listbox in the properties, even if it is in a userform.

    Regards,
    Eddie
    HelpExcel.com

  3. #3
    Registered User
    Join Date
    07-16-2010
    Location
    CO
    MS-Off Ver
    Excel 2003
    Posts
    18

    Re: User Form List items to link to other sheets in the workbook

    does the row source property allow me to click and link on individual list items in the list box?

    I made a user form that spit out results to a text box but I changed it to a list box and I would like to use it to link the items in the list box to worksheets in the workbook. I read somewhere that I can't use the addItems and rowsource properties together.

+ 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