I would create a user form with a combo or list box with your options in it.
triger it with userform1.show and give it an "Apply" button to insert the
value and close the userform.

"Pluggie" wrote:

Part of my macro now has this line.

Range("D2").FormulaR1C1 = "CTR"

It enters the value "CTR" in a cell.

Now I need to modify it, so that it opens up a box in which the user can
select a value from a list of 3 options.

How do I do this?
What code do I need?