Search on sheets depending on combobox value

Hello, could you please help me with this.

I have this excel file with userform that search in sheets.
Here i just want, when i choose the month in combobox, it will search in corresponding sheets. I have attached the sample file


For example: If i choose "January" in combobox, and enter task number "4401" it will will search in January sheet and give me a result of PM=2, SA=5, IS=10 and Assoc IS/IDE=11

or when i chose February and enter task number 4401, it will search February sheet, PM=5, SA=5, IS=5 and Assoc IS/IDE=5.

if March and 4401, PM=5, SA=4, IS=17 and Assoc IS/IDE=10.

*** bump ***

Hi John, if D2 of Sheet is blank, it will pop-up a message "BoE for this month is not yet available.

When i added your code to the line, it works only for the sheets with data, but if you choose the sheet(month) with blank data, and entered the task number, it will stuck in "You have entered an Invalid Task Number". I've attached the modified file.

For Example: if i choose "June", and enter number in task number, it will display a message "BoE for this Month is not yet available".

Also, i just want to pop-up a message "Select Month First" when they try to enter task number without selecting month.

That's what i looking for John! Perfect! Thank you so much!.. uhmm.. by the way could you please help me with my another thread?

here's the link http://www.excelforum.com/excel-prog...41#post3151941

Hi John, what if the data source is in the other worksheet and not in the same worksheet of the userform? how can i set the worksheet to search it on that path?

For example: the data source is save in "C:/Data Source.xlsx" <-- containing January - December sheets. When i run the userform, it will search in C:/Data Source.xlsx