Excel 2010: Dropdown list with user input after

[Taemex]

I'm struggling reckoning how to do this and could use some help. Here is what I'd like to do:

1. User selects item from a list in a drop down menu via data validation to a named range. There are {ten} cells with data validation to check.
2. Once item is selected, if the item meets criteria that requires more user input, a request for more input pops up (most likely via a text box + Enter).
3. The cell with the initial data validation is changed to it's initial value plus whatever the user put as input.

Ex.:
-Of the ten cells with data validation, the user selects the third cell. The drop down list contains; apple, orange, grape, banana.
-When the user selects apple, what looks like a message box pops up and asks the user what type of apple this is to be. The user inputs whatever he wants and presses the enter key, in this case the user puts, "Fuji".
-The cell with the data validation is changed to show the original selection plus what the user puts, i.e. "apple: Fuji".

If someone could give me a general idea of how to accomplish this, I'll have no trouble coding it or making a user form. I'm basically stuck where the code determine which cell contains "apple" in the list, and how to output this so I can alter that cell with the user form. Code wise, my idea thus far is:

Please Login or Register  to view this content.

[Taemex]

Alright, was much easier than I thought, but getting a ton of problems...

Please Login or Register  to view this content.

In theory, this should check if boxes BJ77 through BJ113 have the word Craftsman, and if so put up an InputBox where the user can input a value and press Enter and the box with the change will be changed to show Craft: User Input. What happens with the On Errors active is an endless loop each and every time I type anything in boxes BJ77 to BJ113. Without the On Error, it will work as intended unless I type in Craftsman and then backspace it, or backspace any text I typed in any boxes, at which point I get a Run-time error '13': Type mismatch. I'm not sure what the problem is here; obviously it's a type-mismatch based on a "" value, but that doesn't make any sense to me why this should be happening!

EDIT: It would seem 10th tries a charm with Google. I just had to search for the right criteria I guess.

I had to include this before my "If" statement, and remove my On Errors:

Please Login or Register  to view this content.