+ Reply to Thread
Results 1 to 3 of 3

Show results from a sheet in a userform

  1. #1
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Show results from a sheet in a userform

    Hello

    I use advanced filter and i get my results in sheet C14PR.

    In this sheet in E3:N3 are the headers. Starting from E4 and down the page i have my results.

    What i need is to get all these results(inclunding headers) in a userform. Should be a listbox in the userform?

    Thanks in advance for any assistance here!

  2. #2
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Show results from a sheet in a userform

    Yes a listbox with rowsource set to "'C14PR'!E4:N1000" and columnheads set to true. You must change the 1000 to match your data. Please note that you must not include the column header row in the rowsource text.
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  3. #3
    Forum Contributor MariaPap's Avatar
    Join Date
    10-19-2013
    Location
    Chania-Crete-Greece
    MS-Off Ver
    Excel 2003-2010
    Posts
    319

    Re: Show results from a sheet in a userform

    Apologize for the delay.

    Yes this works. Thank you!

+ 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. Userform:Search through all ws / show results in Listbox
    By wali in forum Excel Programming / VBA / Macros
    Replies: 20
    Last Post: 01-22-2015, 09:56 PM
  2. Show Search results in userform and edit
    By cruiser102 in forum Excel Programming / VBA / Macros
    Replies: 25
    Last Post: 12-21-2012, 07:57 PM
  3. Show Search results in userform
    By StartingOut in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-20-2012, 07:51 PM
  4. [SOLVED] VBA code needed to show the results through UserForm
    By krjoshi in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-01-2012, 04:19 PM
  5. UserForm to search sheet, show results on separate userform?
    By egemenkepekci in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-25-2010, 01: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