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 |
All times are GMT +1. The time now is 12:44 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com