Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combobox list - only with rows that fit the criteria
Hi
I have a userform with combobox ("complaintdis") that displays items in column A of worksheet "ComplaintData". The rowsource of this combobox is based on a dynamic name range created in the worksheet, so the rowsource grows as the entries in the worksheet grow. The problem I have is this: My worksheet ("ComplaintData") has 10 columns that store various details for each record, with heading from A1:J1. Every record does not have a entry in the column J to start with. And then users keep adding their "feedback" to various records in no particular order which gets stored in column J in front of relevent record. (only one feedback per record) I am wondering if there is anyway I can get the combobox ("Complaintdis") to display the records with their column J empty......in other words I would like the combobox to only display records with no feedback in column J. But remember that values shown in the combobox list are from column A of that record. is this posssible?? someone told me about removeitem or additem function .....but i cant seem to figure it out.... would appreciate any help! cheers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I insert 4 rows in between each value in a list of data | Excel Discussion (Misc queries) | |||
dependant combobox list | New Users to Excel | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions | |||
Count rows based on multiple criteria | Excel Worksheet Functions |