Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pick from list
Hi,
I hope someone can help me... is there a way to have a combobox on a userform get its list populated from the contents of 'pick from list' (that you have when you right click on a cell in a table of data)? I want the combobox to have a list based on what has already been entered in the column, but not include duplicates (so even if i can't access the values i 'pick from list', maybe there is some other way?). i hope that makes sense, tia, Tim |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pick from list
Not directly.
You can build a list of uniques using a collection object or a dictionary object. See John Walkenbach's site for an example. http://www.j-walk.com/ss/excel/tips/tip47.htm -- Regards, Tom Ogilvy "Tim Marsh" wrote: Hi, I hope someone can help me... is there a way to have a combobox on a userform get its list populated from the contents of 'pick from list' (that you have when you right click on a cell in a table of data)? I want the combobox to have a list based on what has already been entered in the column, but not include duplicates (so even if i can't access the values i 'pick from list', maybe there is some other way?). i hope that makes sense, tia, Tim |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
pick from list
thanks Tom. modified as required and working perfectly.
(",) "Tom Ogilvy" wrote in message ... Not directly. You can build a list of uniques using a collection object or a dictionary object. See John Walkenbach's site for an example. http://www.j-walk.com/ss/excel/tips/tip47.htm -- Regards, Tom Ogilvy "Tim Marsh" wrote: Hi, I hope someone can help me... is there a way to have a combobox on a userform get its list populated from the contents of 'pick from list' (that you have when you right click on a cell in a table of data)? I want the combobox to have a list based on what has already been entered in the column, but not include duplicates (so even if i can't access the values i 'pick from list', maybe there is some other way?). i hope that makes sense, tia, Tim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Look up list of values based on single value from pick list | Excel Discussion (Misc queries) | |||
Pick List Box | New Users to Excel | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Pick list | Excel Discussion (Misc queries) | |||
Pick From List | Excel Discussion (Misc queries) |