SimoninParis
New Member
- Joined
- Mar 2, 2012
- Messages
- 25
Hello out there,
Can anybody help me?
I am building an Excel workbook in which the main data worksheet has 47 fields. The first field is a unique numerical reference number, the last is a date stored as an integer. The remainder are either string or byte (derived from true/false from a userform). I need to be able to construct a search subroutine to return records matching up to 22 criteria from a "Search Userform". In addition, the subroutine needs to be able to identify one field which may contain " "xxx" AND/OR "yyy" AND/OR "zzz" ".
Do I need a search array? Do I need MATCH and/or Instr?
My VBA powers have met their match and been found wanting.
Any help, advice and/or guidance would be gratefully received.
Can anybody help me?
I am building an Excel workbook in which the main data worksheet has 47 fields. The first field is a unique numerical reference number, the last is a date stored as an integer. The remainder are either string or byte (derived from true/false from a userform). I need to be able to construct a search subroutine to return records matching up to 22 criteria from a "Search Userform". In addition, the subroutine needs to be able to identify one field which may contain " "xxx" AND/OR "yyy" AND/OR "zzz" ".
Do I need a search array? Do I need MATCH and/or Instr?
My VBA powers have met their match and been found wanting.
Any help, advice and/or guidance would be gratefully received.