dynamic list box creation

[mpgutta]

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

[Leith Ross]

Hello mpgutta,

There are of few different types of List Boxes. Can you be more details about the List Box you want to add? Do you want it to work like a Data Validation list where the Drop Down button appears only when the cursor is on the cell? Or do you want it as fixed size on the worksheet?

Sincerely,
Leith Ross

[royUK]

Split the list & use Data Validation >- List

[MickG]

Hi, I'm not sure exactly what you want, but this bit of code will take the information from sheet(2) "A1" and place it in a List Box or Combobox in sheet (1), as per selected code (Boxes from the "Control ToolBox" menu)
Place a Combobox or List Box in Sheet(1) and run either of the codes from sheet (2).

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards Mick