I have a table called npss_quote. The header row is A10:M10 with the data starting in row 11. Column B for each row in the table has a data validation list referring to a list of 7 items. Upon the selection of one of the items, Activities, I want a pop up msg box to appear. This allows you to enter a figure and when you press ok, it puts the figure into column M of the table row. Can someone help me with the vba code please?