+ Reply to Thread
Results 1 to 9 of 9

Running a calculation based on a drop down list

  1. 03-19-2012, 05:36 PM #1
    imogul
    imogul is offline
    Registered User
    Join Date
    04-07-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    49

    Unhappy Running a calculation based on a drop down list

    My office is stuck using excel 2002 for the foreseeable future. I'm trying to create a drop down box. I don't think validation is gonna get the job done here because I don't want anyone to type in the box. I just want them to click on it, pick an item type from the list (lbs, cubic feet etc) and then type a number into the box next to it. I'm building a conversion chart that will apply a formula against the number based on what item is picked from the drop down list. But first things first.

    Can anyone tell me how to build a drop box / drop down list of static choices in 2002?


    Thanks for reading my post.
    -Mogul
    Last edited by imogul; 03-19-2012 at 06:51 PM. Reason: Solved
    Reply With QuoteRegister To Reply
  2. 03-19-2012, 06:19 PM #2
    icestationzbra
    icestationzbra is offline
    Forum Expert icestationzbra's Avatar
    Join Date
    01-07-2004
    MS-Off Ver
    2007, 2010
    Posts
    1,421

    Re: Running a calculation based on a drop down list

    i do not have access to XL 2002, but i vaguely remember Form Controls-based Combo Box and List Box being useful in similar situations on 2003 (i hope it is valid for 2002, too).

    according to XL 2007, the navigation might be ALT+L+I followed by C for combo box or I for list box. once selected, you would have to draw on the sheet to get a shape, then right-click and Format Control > Control > Input Range and Linked Cell.

    see if that helps.
    Reply With QuoteRegister To Reply
  3. 03-19-2012, 06:41 PM #3
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Running a calculation based on a drop down list

    Hi

    You mean something like this??
    Attached Files Attached Files
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.
    Reply With QuoteRegister To Reply
  4. 03-19-2012, 06:50 PM #4
    imogul
    imogul is offline
    Registered User
    Join Date
    04-07-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    49

    Talking Re: Running a calculation based on a drop down list

    Yup that looks like just what I need. I hope there is a very attractive person kissing you right now!

    Thanks!
    Reply With QuoteRegister To Reply
  5. 03-19-2012, 07:04 PM #5
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Running a calculation based on a drop down list

    Is your answer for Me???!
    Reply With QuoteRegister To Reply
  6. 03-19-2012, 07:21 PM #6
    imogul
    imogul is offline
    Registered User
    Join Date
    04-07-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Running a calculation based on a drop down list

    Yaaar. Turns out what you posted wasn't exactly what I needed. However it popped up the "control toolbox" tool bar which IS what I needed. I just couldn't remember what the thing was called in 2002. So if anyone else stumbles upon this thread, just right click on an empty section of tool bar, click on control toolbox. Then in your new toolbar, click on the "design mode" button. Then click on the design box of your choice (I went with combo box), and get to box'n!
    Reply With QuoteRegister To Reply
  7. 03-19-2012, 07:28 PM #7
    Fotis1991
    Fotis1991 is offline
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Running a calculation based on a drop down list

    you are welcome!

    I'll ,just now, will go to my wife and tell her, that i have an admirer!
    Reply With QuoteRegister To Reply
  8. 03-19-2012, 07:30 PM #8
    Haseeb Avarakkan
    Haseeb Avarakkan is offline
    Forum Guru
    Join Date
    05-24-2011
    Location
    India
    MS-Off Ver
    Office 2021
    Posts
    2,237

    Re: Running a calculation based on a drop down list

    If you select "Control toolbox" combo box, this will ask to enable/disable macros when opening your file. You can use 'Form toolbox' instead.

    See here
    Regards,
    Haseeb Avarakkan
    __________________________________
    "Feedback is the breakfast of champions"
    Reply With QuoteRegister To Reply
  9. 03-20-2012, 12:29 PM #9
    imogul
    imogul is offline
    Registered User
    Join Date
    04-07-2011
    Location
    California
    MS-Off Ver
    Excel 2010
    Posts
    49

    Re: Running a calculation based on a drop down list

    Excellent. Thank you Haseeb, I will try that as well. Also thanks to icestationzbra who said something similar as well.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1