View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Pluggie Pluggie is offline
external usenet poster
 
Posts: 23
Default Have macro force user to selecat a value

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?