Hi all,

I recently posted this thread

This previous query was solved. I now have another query.

On the same userform as described in the thread linked above I have another method of searching my worksheet that provides the user a faster return on their query providing they know the title's SKU number.

Originally I had the following code in place, designed to only inform the user which row to title was located on so that they could manually navigate there. Now that the combobox query has been solved from my last thread, I'd like to have this SKU search textbox function the same as the combobox, while still retaining some key aspects of the original code; namely the error reporting and success notification.

Original code

Please Login or Register  to view this content.
The new code for populating the eight development stage textboxes is copied and modified from the previous thread's solution. 

Please Login or Register  to view this content.
My query is, how can I merge these two chunks of code so that the search bar reports a "SKU not found" when; A) the Search command button is selected while the search textbox is empty. B) when the SKU is entered incorrectly.

In addition, when the SKU is entered correctly, a message to say it has been found (but doesn't need to report the row anymore though) and then populate the development stage textboxes with the relevant values from the Data worksheet (like the combobox from the other thread does).

If there's any additional information you may need in order to help with this query, please ask.

Many thanks in advance!

A Grace