Results 1 to 4 of 4

dynamic list box creation

Threaded View

  1. #1
    Registered User
    Join Date
    08-01-2008
    Location
    India
    Posts
    2

    dynamic list box creation

    Hello,
    I have all candidate names in cell A1 of sheet2 joined by ||_ special character. ( eg. Mohan||_Prasad||_Gutta).
    my aim is to split the candidate name and have to provide those names in a drop down list in sheet column A of Sheet1 for all the cells.
    i have written code to get data from the sheet2 and splitting the information using seperator ||_
    I thought of making use of a function which will do all these action.
    But i am not sure how to create a list box in the cell dynamically from the macro function
    could you please tell me how to achieve this.
    Thanks in advance.
    Kind Regards,
    Mohan
    Last edited by mpgutta; 08-27-2008 at 03:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Create a dynamic list from multiple sheets
    By shbiskup in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-28-2022, 04:04 AM
  2. Dynamic Drop Down List...with Criteria
    By TimE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-17-2008, 11:43 AM
  3. reference to a dynamic cell in a list?!
    By rjmills18 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-16-2008, 09:13 AM
  4. List Box based on dynamic "Name"
    By ChrisMattock in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-26-2007, 06:06 PM
  5. Dynamic list of customers
    By bill_s1416 in forum Excel General
    Replies: 1
    Last Post: 10-10-2006, 09:14 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