+ Reply to Thread
Results 1 to 3 of 3

ComboBox Selections to Preview in ListBox before posting to Range

  1. #1
    Registered User
    Join Date
    03-26-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    4

    ComboBox Selections to Preview in ListBox before posting to Range

    I have thought about different approaches to accomplish what I am trying to do. I have a Userform with four ComboBoxes and a ListBox. I also have a worksheet (Data) for data in the Userform to go to.

    I want to select the information I want in the ComboBoxes, use a command button (Add) to have the ComboBox selections appear in the ListBox window - to in a way act as a preview before submitting. Then after "adding" up to 10 lines in the ListBox window - use a command button (Send ListBox Data to Worksheet) to send the ListBox Data to the Worksheet. This is a piece of an invoicing/quoting system I want to develop.

    First Approach Considered
    :
    Use the command button (Add) to transfer data to worksheet, then refresh the ListBox to show data in the worksheet range in the ListBox.

    Second Approach Considered:
    Add information first to ListBox then transfer ListBox data to worksheet range.

    I am if my approach to what I am trying to accomplish is in the right direction and/or thoughts on how to proceed.

    I have attached a Sample Worksheet to give an idea of what I am wanting to do. I am aware of how to input the ComboBox data to the worksheet. But not how to refresh the ListBox without closing the Userform. I have learned how to add selections to a ListBox. I have not been able to figure out how to add multiple ComboBox selections to the ListBox in contiguous horizontal columns, then repeat that in contiguous vertical rows.

    I did my best to make sense! Any thoughts?
    Attached Files Attached Files
    Last edited by lumin30; 03-30-2012 at 11:23 PM.

  2. #2
    Registered User
    Join Date
    03-26-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    4
    Maybe I need to add that I attached the sample workbook to help demonstrate what I am looking to do - not to have somebody spend time coding for me. I am looking to be pointed in the right direction if somebody can help.

  3. #3
    Registered User
    Join Date
    03-26-2012
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Userform ComboBox Selections to ListBox to Worksheet Range

    Any suggestions on how I can rephrase my question to have a knowledgeable member give me any sort of reply?
    Last edited by lumin30; 03-28-2012 at 11:08 AM.

+ 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