+ Reply to Thread
Results 1 to 4 of 4

Combo Box list filling and export the selected data to another worksheet

  1. #1
    Registered User
    Join Date
    12-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    45

    Combo Box list filling and export the selected data to another worksheet

    Hello Forum,

    I am not that good with Combo-boxes.

    I have a combo-box in a Multipage control. Now I want to get the combo-box populated with list in 2 columns from 2 different consecutive columns from the same worksheet (Product List). Now, Once the list gets populated, user will be selecting his choice from the list, which is then needs to get copied to another worksheet (Order Placed). Both worksheets exist in the same or one spreadsheet.

    I am trying to make it work with the following code. I am able to see 2 columns but with no data getting populated. I am working in MS Excel 2007.
    Please Login or Register  to view this content.
    Please help me

    Regards,
    Sailaja A

  2. #2
    Registered User
    Join Date
    12-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Combo Box list filling and export the selected data to another worksheet

    As the first row of the 2 columns are column headings, I tried with following code also.

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    12-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Combo Box list filling and export the selected data to another worksheet

    Great! I found it my self, but to an extent.
    I am able to populate the required list in columns, but only first 2 rows are getting populated. Where is the mistake

    Renewed code:
    Please Login or Register  to view this content.
    Help needed !

  4. #4
    Registered User
    Join Date
    12-17-2013
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    45

    Re: Combo Box list filling and export the selected data to another worksheet

    Hello again forum,

    I am finally concluding this post with my successful code. Hope it helps others too !

    Please Login or Register  to view this content.

+ 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. Run a different macro when an entry is selected in a combo box drop down list
    By ic1234 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-10-2013, 11:59 AM
  2. Need VBA for Combo box and Data Validation list to find same value in another worksheet
    By jhudson321 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-28-2012, 08:45 AM
  3. Add combo list with user defined data in selected cell in Excel 2003
    By sakthivel.s in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2009, 05:45 AM
  4. Filling in cells with user selected data
    By Raggy in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-29-2008, 04:52 PM
  5. Replies: 1
    Last Post: 04-15-2005, 07:07 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