Cell Dropdown Help

[Digger]

Im completely new to this so please be patient.
What I am after is to have a cell with a drop down that has a list of sizes and when a size is chosen the corresponding price of that size shows in the cell not the size.
Or.
The size and price can show on the dropdown but when the choice is made I only want the price to show.
Thanks in advance

[MartinShort]

There are quite a few ways to do this and I imagine that at least one person will scream at me for this solution, but my favourite is as follows:

1. From the control toobox toolbar, add a combo (dropdown) to the worksheet.

For this example, I have added a lookup column in D1:D3 (the sizes column) and a corresponding values column to E1:E3 (prices). My output is stored in G1. In design mode, right click the combo and pull up the properties and alter as follows:

2. Set ListFillRange to be D1:E3
3. Set LinkedCell to be G1

4. Set ColumnCount to be 2 (Sets the number of columns selected to be 2)
5. Set Bound Column to be 2 (Sets the output to be the second column)

8. Set ColumnWidths to be 055pt;0pt (only displays the first column in the dropdown)

9. You can then copy and paste the combo as many times as you want, altering the LinkedCell property for each one.

Hope this helps
MS

ps if you're not familiar with embedding objects in your spreadsheet, don't forget to toggle between Design Mode and Exit Design Mode from the Control Toolbox Menu.