Use a list or dropdown box from the forms toolbar. Click it on the toolbar,
rubberband a location on the worksheet. right click on the control and
select format control. On the control tab, there are areas for Input Range
and Cell Link. click in Input range, then navigate to your data and
highlight it. Do the same for Cell Link, specifying which cell you wish to
link to.

--
Regards,
Tom Ogilvy

"Phil Hageman" wrote in message
...
I have a workbook saved as a template - I want users to enter/select data
only on this form, then save it somewhere else. On the first worksheet
named "BSC Rationale", I want a List or Combo box where the user selects
from a dropdown list, whence the selection is displayed in the control. The
values for the control are on the second worksheet, named "Variables" (out
of sight from the user). I want to set up a number of such controls on this
form.

Can someone advise how to go about this? I know it must be simple, but
the example in the book I'm using doesn't work. I've tried both list and
combo boxes - to no avail.