Multiple Choice Selection Msgbox based on Cell Value

Question

I need a message box to pop up when I enter data in a cell that allows me to choose from a list of items. Then enter a value in a specific cell.

In column A, I have a list of items the customer will choose during their design. In column B, the item part number will be entered for the item they choose. All items have a color code attached which is a sale price. Based on Color will be the discount.

What I'm looking for is a msgbox similar to vbYesNoCancel. As soon as the part number is entered in Column B, I would like a msgbox to pop up where they can then select the Color of the item. (There are 6 Color or discount codes.) When they choose a color, It would enter the color in Column C. From there, Formulas will do what needs to be done.

I can get it to work great with the vbYesNoCancel. but I need it to say Green, blue, Yellow, Red, Purple, and Orange., not yes, no or cancel. I thought about creating a list box, but I'm not advanced enough to know how to call the List box on a cell value change.

I'm struggling to figure this out. This also needs to be very user-friendly.

Any help would be very much appreciated.