IF statement from a combo box

**Attrition** · 02-09-2014, 01:13 PM

On Sheet 1, I have a combobox that has 3 options. on sheet 2, i am going to have different formulas from each of those options. Should I be going to format control on the combobox and then linking the combobox box to a cell? Ive done this in the excel doc attached.

Should I be using the IF function for a formula on sheet 2 that would call the chosen option from sheet 1 and assign a numerical value to it? For instance, if I wanted:

Red = 1
Yellow = 2
Green = 3

If ive linked the combo box to b2 what would the if statement be? or is there an easier way to do this?

Thanks

**6StringJazzer** · 02-09-2014, 05:01 PM

I think you are on the right track but it's not clear what result you are looking for. What do you want to happen in each of three cases where the user selects red, yellow, or green? More specifically, what does this mean: "i am going to have different formulas from each of those options"

**Attrition** · 02-09-2014, 08:51 PM

well i want a cell on sheet 2 to change values based on the option chosen from the combo box on sheet 1. I tried doing this for a cell on sheet 2 but it didnt work.

=IF(Sheet1!B2="Red",1,0)

Any ideas?

**6StringJazzer** · 02-09-2014, 10:08 PM

You still haven't said what results you want, but here is the idea:

=CHOOSE(Sheet1!$B$2,"The user picked Red","The user picked Yellow","The user picked Green")

Edit: The cell linked to the combo box does not have the value that the user selected, it has an index to that value. If you try to use your combo box, you will see that cell B2 contains 1, 2, or 3 (not "Red", "Yellow", or "Green").

**Attrition** · 02-09-2014, 10:13 PM

This issue is im still working out what the results for the options are supposed to be. So i apologize if im being confusing.

I just tried that and it works for red, but not when the user actually chooses yellow or green. But yes, this is exactly what im looking for!

**6StringJazzer** · 02-09-2014, 10:38 PM

Here is your file, see formula added in Sheet2!A1. Works OK for me.

**Attrition** · 02-09-2014, 11:57 PM

Thanks 6String.

It seems to only work then I go click on the formula into the cell and press enter. Is there a way to have the value in sheet2!a1 change whenever the combobox value is changed and not having to press enter in sheet2!a1?

**6StringJazzer** · 02-10-2014, 08:12 AM

That is not what I see but I am using 2010. I don't know of anything that would make 2003 behave differently. Will it update if you hit F9 instead of editing the cell? If so you may have Autocalculate turned off. Check: Tools > Options > Calculation > Calculation > Automatic.

**Attrition** · 02-10-2014, 09:37 AM

thats waht the issue was thanks!

IF statement from a combo box

LinkBack

Thread Tools

Rate This Thread

Display

IF statement from a combo box

Re: IF statement from a combo box

Re: IF statement from a combo box

Re: IF statement from a combo box

Re: IF statement from a combo box

Re: IF statement from a combo box

Re: IF statement from a combo box

Re: IF statement from a combo box

Re: IF statement from a combo box

Thread Information

Users Browsing this Thread

Similar Threads

If then else statement for a combo box

If statement to change Combo box's Row-source?

If statement for a combo box

IF Statement for Combo Box List

If Statement for Combo Box List

Bookmarks

Bookmarks

Posting Permissions