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.