+ Reply to Thread
Results 1 to 4 of 4

listbox.rowsource

  1. #1
    Registered User
    Join Date
    01-22-2010
    Location
    syria
    MS-Off Ver
    Excel 2007
    Posts
    10

    listbox.rowsource

    Hello
    I "nyef" from Syria
    I want to put in the column headings "listbox" exactly as it is in the sheet, but non-contiguous columns
    Attached Files Attached Files

  2. #2
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: listbox.rowsource

    Move the Age column to Column-C and keep the Work Column to Column-B

    Select the list box in your form press F4 and set the below values in the concerned property.

    Row Source
    ='P2'!A2:B6

    ColumnHeads
    True

    Column Count
    2


    If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
    Mark your thread as Solved


    If the suggestion helps you, then Click *below to Add Reputation

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419

    Re: listbox.rowsource

    You can hide columns by using the columnwidths property.

    The issue is more that the OP is using List and Additem to alter the contents, which you can not do once RowSource is set
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Guru :) Sixthsense :)'s Avatar
    Join Date
    01-01-2012
    Location
    India>Tamilnadu>Chennai
    MS-Off Ver
    2003 To 2010
    Posts
    12,767

    Re: listbox.rowsource

    Quote Originally Posted by Andy Pope View Post
    The issue is more that the OP is using List and Additem to alter the contents, which you can not do once RowSource is set
    Oopss... Yes I have not noticed it.

    Thanks for the correction Andy

+ 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. [SOLVED] ListBox RowSource
    By CobraLAD in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2013, 02:08 AM
  2. Setting Rowsource for Listbox
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 09-30-2010, 11:21 AM
  3. filter listbox without rowsource
    By WCJanssen in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2009, 08:32 AM
  4. [SOLVED] Listbox - Rowsource
    By Paul W Smith in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-24-2006, 05:30 PM
  5. [SOLVED] RowSource in ListBox
    By Noah in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-17-2005, 10:10 AM

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