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 Im using doesnt work. Ive tried both list and combo boxes €“ to no avail.

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.

Just drop a combobox from the Forms toolbar on to the sheet. Right-click it
and use Format Control to set the Input Range.

--
Jim Rech
Excel MVP
"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.
|

Thanks, Tom - works just right.