Let me see if I got a solution to your problem straight:
Assuming your research and development options are in column A and the cost in column B, as per my attached sheet, then I want to use a list box from Control Toolbox, not Forms, and C2 is the LinkedCell.
Book8 |
---|
|
---|
| A | B | C | D |
---|
1 | R&D | | | |
---|
2 | East | $100.00 | East | |
---|
3 | North | $200.00 | $ 100.00 | |
---|
4 | South | $300.00 | | |
---|
5 | West | $400.00 | | |
---|
6 | | | | |
---|
|
---|
Install the List Box from Control Toolbox, right and select Properties. Type (you need to type) in C2 as the LinkedCell.
Edit: The List Box isn't displayed in the picture above.
Right under that row type in the range of your development options as the ListFillRange. In my case it would be A2:A5.
Exit the Design Mode by clicking on the top left button (Design Mode) for that toolbox. If you later need to alter the range select Control Toolbox, right click, select Properties and enter Design Mode.
EDit: Select the range of research options and the cost (A2:B5 in my case) and click in the Name Box (next to the Formula Bar), (where you see C3 in the above example) and type in the name of that range. I called my range Research, as per the formula in C3.
The formula that returns the cost is in C3.
Hope This Helps
RAM