jimmywanna
Board Regular
- Joined
- Mar 18, 2002
- Messages
- 182
I've done this recently.
What i did was made a combobox from the "forms" toolbar. Then in the range prompt selected the range of options from the workbook. Then in another cell You make the "link". In the cell you want the selected option to appear type"Index=(First cell in range:last cell in range, link" it works a treat.
What i did was made a combobox from the "forms" toolbar. Then in the range prompt selected the range of options from the workbook. Then in another cell You make the "link". In the cell you want the selected option to appear type"Index=(First cell in range:last cell in range, link" it works a treat.