teaaddict
07-31-2009, 09:28 AM
Hi
I have created an Excel spreadsheet which has several columns listing a number of variables e.g. location, hours per week etc.
I've also created the basics of a userform which has a number of boxes to input the variables and a command button which when clicked needs to:
- search for a match of ALL entered variables within the columns on the spreadsheet
- when it finds a match(es), it then extracts the information provided in another column and displays this in a message box
- if it doesn't find a match which satisfies all the variables entered the message box displays an unsuccessful message
If anyone has any idea how to make this work it would be much appreciated!
Cheers
Jess
I have created an Excel spreadsheet which has several columns listing a number of variables e.g. location, hours per week etc.
I've also created the basics of a userform which has a number of boxes to input the variables and a command button which when clicked needs to:
- search for a match of ALL entered variables within the columns on the spreadsheet
- when it finds a match(es), it then extracts the information provided in another column and displays this in a message box
- if it doesn't find a match which satisfies all the variables entered the message box displays an unsuccessful message
If anyone has any idea how to make this work it would be much appreciated!
Cheers
Jess