V
Vikram
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
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