Getting list of values from the excel cell

I have an Excel Sheet on which i have created a List consisting of many values. also I have created a macro which shows a user form in which those values are hard coded. Now I want that Those values in the form should automatically/Pro grammatically/dynamically added to my user form list. so that in the future if i want to decrease the values from the list then i would not have to change the macro again. I have been searching looking for the answer but its of no use? anyone know?

You have not made it clear what you need.

Is your list of items in a column?

Why can't you use something like:

Please Login or Register  to view this content.

Acutally The values I want to get in excel cell is in the form of list. and has a filter enabled. and i want to add those values in user form list box.

I've been waiting for Leith Ross to reply since I would assume that his answer will be better than mine. I looked into this problem a couple months back, and one would think that there should be a simple answer to your question, but I didn't find it.

I did find: http://www.techrepublic.com/blog/how...t-in-excel/111 by Susan Harkins.

I didn't like Harkins solution because it ended up copying the filtered list to some obscure region of the worksheet and then used that region to move the items into a combobox or listbox (they use similar methods).

So instead of using a filtered list method like Harkins suggest, I ended up creating a function which would create a unique list from a column of items.