checkbox / radio button or combo-box???

Which is the best one to use if i need to create an ordering form where the user selects an option and it shows the value of that item in a seperate cell?

e.g.

Intel Celeron Processor 2.53 GHz (Standard)
Intel Celeron Processor 2.66 GHz
Intel Celeron Processor 2.80 GHz
Pentium 4 HT 2.8 GHz 1Mb Cache 800 MHz FSB
Pentium 4 HT 3.0 GHz 2Mb Cache 800 MHz FSB
Pentium 4 HT 3.2 GHz 2Mb Cache 800 MHz FSB
Pentium 4 HT 3.4 GHz 2Mb Cache 800 MHz FSB

£0.00
+£4.00
+£8.00
+£73.00
+£84.00
+£110.00
+£149.00

If the user selects Intel Celeron Processor 2.66 GHz +£4.00 is added to the standard price of £360

everytime I try using a radio button it just give the order the item is in the list how do i make that the price of the selected item?? a check box just says true and a combo box does the same as the radio button.

Cheers

I would use a combobox from the forms toolbar and set up a table on a hidden
sheet that looks up the number that is returned from the combobox, using the
INDEX function like so

1) Enter your processor type on a sheet with there respective surcharges
alongside (I used a sheet called Data and a range of A2:B8)
2) Drop a combo box on another sheet, right click and select format control
3) In the 'Input Range' select the cells with the processor names in (A2:A8
in my example)
4) In the 'Cell Link' enter any cell reference near to your processor list
and surcharges (I used D2)
5) Where you want to show the selected value enter the formula

=INDEX(Data!$A$2:$B$8,Data!D2,2)

This will display the surcharge for the processor displayed in the combobox

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk


"ko6ad" <[email protected]> wrote in
message news:[email protected]...
>
> Which is the best one to use if i need to create an ordering form where
> the user selects an option and it shows the value of that item in a
> seperate cell?
>
> e.g.
>
> Intel Celeron Processor 2.53 GHz (Standard)
> Intel Celeron Processor 2.66 GHz
> Intel Celeron Processor 2.80 GHz
> Pentium 4 HT 2.8 GHz 1Mb Cache 800 MHz FSB
> Pentium 4 HT 3.0 GHz 2Mb Cache 800 MHz FSB
> Pentium 4 HT 3.2 GHz 2Mb Cache 800 MHz FSB
> Pentium 4 HT 3.4 GHz 2Mb Cache 800 MHz FSB
>
> £0.00
> +£4.00
> +£8.00
> +£73.00
> +£84.00
> +£110.00
> +£149.00
>
> If the user selects Intel Celeron Processor 2.66 GHz +£4.00 is added to
> the standard price of £360
>
> everytime I try using a radio button it just give the order the item is
> in the list how do i make that the price of the selected item?? a check
> box just says true and a combo box does the same as the radio button.
>
> Cheers
>
>
> --
> ko6ad
> ------------------------------------------------------------------------
> ko6ad's Profile:
> http://www.excelforum.com/member.php...o&userid=31319
> View this thread: http://www.excelforum.com/showthread...hreadid=510075
>