Eurekaonide
Active Member
- Joined
- Feb 1, 2010
- Messages
- 422
Hi All
I wan to load up a simple combobox in a form - the data in the drop down comes from a named range in my workbook elsewhere. I can get the form to load etc, but I want to identify the item chosen by the user and then use that to find all the rows of data that equal that data set.
For example if they select that they have brown hair, in my data set I want the column which states hair colour to delete all rows out completely that do not equal brown hair, so that the data set that is left is all those with brown hair.
Can anyone suggest to me the best code to use for this please?
Thank you
I wan to load up a simple combobox in a form - the data in the drop down comes from a named range in my workbook elsewhere. I can get the form to load etc, but I want to identify the item chosen by the user and then use that to find all the rows of data that equal that data set.
For example if they select that they have brown hair, in my data set I want the column which states hair colour to delete all rows out completely that do not equal brown hair, so that the data set that is left is all those with brown hair.
Can anyone suggest to me the best code to use for this please?
Thank you