+ Reply to Thread
Results 1 to 3 of 3

Copying data from Spreadsheet to List Box in a UserForm

  1. #1
    Registered User
    Join Date
    02-12-2008
    Posts
    48

    Copying data from Spreadsheet to List Box in a UserForm

    Hi. I must say I have learned quite a lot from this forum. So, a vey big Thank You to the folks who are managing this forum and those who are contributing possible solutions. I have a question about copying data from a spreadsheet to a List Box in a User Form (Pls see attached). First, I select the Account from the drop-down cell in the Main sheet. Then I click on the CommandButton and a UserForm will pop out with a List Box that draws relevant data from the Remarks sheet according to the Account that I have selected. The data in the List Box must be in this format : "Date1 : Remark1"; next line "Date2 : Remark2; line 3 "Date3 : Remark3"........until the last available entry. Any help I could get is greatly appreciated.
    Last edited by grumpyguppy; 11-25-2008 at 05:13 AM.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    re: Copying data from Spreadsheet to List Box in a UserForm

    Filling listboxes and comboboxes can be found on many internet sites. I've picked one from http://www.dailydoseofexcel.com/arch...stboxcombobox/and implemented that into your sheet.
    Attached Files Attached Files
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    02-12-2008
    Posts
    48
    Thanks, rwgrietveld !! That helps a lot !!

+ 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