+ Reply to Thread
Results 1 to 4 of 4

ComboBox and Formulas

  1. #1
    Registered User
    Join Date
    02-20-2007
    Posts
    2

    Red face ComboBox and Formulas


    Hi there,

    My boss and I are currently working on a spreadsheet project for a program she is taking. We have gotten through most of the steps in doing a Sensitivity Analysis of this exercise, however have come to a BIG obstacle and are hoping somebody can help (and please, I'm forwarding this information on to her, so if you could put it in simple terms that would be greatly appreciated).

    What we are trying to do is set a ComboBox inside of a formula, so that if we select a value from the drop-down menu, the formula will change accordingly.

    I am sooo lost and have exhausted all of my patience searching website after website after website, using the Microsoft.com help sites and everything else I can think of. If any of you can help, that would be SO greatly appreciated.

    Thanks.

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by govadmingirl07
    Hi there,

    My boss and I are currently working on a spreadsheet project for a program she is taking. We have gotten through most of the steps in doing a Sensitivity Analysis of this exercise, however have come to a BIG obstacle and are hoping somebody can help (and please, I'm forwarding this information on to her, so if you could put it in simple terms that would be greatly appreciated).

    What we are trying to do is set a ComboBox inside a formula, so that if we select a value from the drop-down menu, the formula will change accordingly.

    I am sooo lost and have exhausted all of my patience searching website after website after website, using the Microsoft.com help sites and everything else I can think of. If any of you can help, that would be SO greatly appreciated.

    Thanks.
    Hi,

    I'm confused.

    What do you mean that you are trying to setup a box inside a formula? - that the result of the formula will display or hide the box?

    Which 'combobox' are you using, the Control Toolbox, the Forms, or the (somewhat mis-named) dropdown menu ?

    If you are using the Combobox from the Control Toolbox menu, then if you set it's linked cell to A1, it's list to A2:A6 and B1 has the formula =VLookup(A1,range,element,False) then B1 will change to match whatever you select.

    If this doesn't help then more information, or a sample 'where you are up to and what you need' worksheet would help.

    ---
    Si fractum non sit, noli id reficere.

  3. #3
    Registered User
    Join Date
    02-20-2007
    Posts
    2

    Red face Clarification

    Hi there,

    Thank you sooo much for your response. I tried to do that, but for some reason that didn't quite work. I'll give you the information you asked for and hopefully that'll clear up what I'm doing.

    So basically, ComboBox I am working in is from Control Toolbox. I don't need a formula to hide or display the box. I need a formula that can pull information FROM the box and calculate it based on some controlled/fixed information that has already been provided.

    Does that make sense? If not I can try to figure some way of getting the spreadsheet to you for visual aid.

    Thanks again for your help! I truly appreciate it.

  4. #4
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by govadmingirl07
    Hi there,

    Thank you sooo much for your response. I tried to do that, but for some reason that didn't quite work. I'll give you the information you asked for and hopefully that'll clear up what I'm doing.

    So basically, ComboBox I am working in is from Control Toolbox. I don't need a formula to hide or display the box. I need a formula that can pull information FROM the box and calculate it based on some controlled/fixed information that has already been provided.

    Does that make sense? If not I can try to figure some way of getting the spreadsheet to you for visual aid.

    Thanks again for your help! I truly appreciate it.
    Hi,

    If you look in the Properties of the box, one item is Linked Cell.

    Set this (say B2), it will then reflect the item chosen and a formula (in B3) can be

    =If(B2="First",C3*7,If(B2="Second",C3*9,C3*11)))

    etc

    Does this help?
    ---

+ 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