checkbox / radio button or combo-box???

[ko6ad]

Which is the best one to use if i need to create an ordering form wher
the user selects an option and it shows the value of that item in
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 t
the standard price of £360

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

Cheer

 

[Nick Hodge]

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