+ Reply to Thread
Results 1 to 2 of 2

checkbox / radio button or combo-box???

  1. #1
    Registered User
    Join Date
    02-08-2006
    Posts
    4

    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

  2. #2
    Nick Hodge
    Guest

    Re: checkbox / radio button or combo-box???

    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" <ko6ad.22x38m_1139413200.6119@excelforum-nospam.com> wrote in
    message news:ko6ad.22x38m_1139413200.6119@excelforum-nospam.com...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1