Refernence combo box in if statement

gbarclay2001

New Member
Joined
Mar 17, 2002
Messages
46
Hi all,

I want to refernce a combo box on my sheet within an IF statement in a cell. e.g. =IF(mycombobox="hello",C1="huihni",C1="njdskds"). What is the correct syntax for the mycmbobox bit?

Many Thanks,

Greg
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.
I'm afraid you can't reference an object in a formula. Instead, you will have to use the LinkedCell property in the ComboBox. Set the LinkedCell to be any blank cell in your worksheet, say M23. Then change your formula to this:

=IF(M23="hello",C1="huihni",C1="njdskds")
 
Upvote 0
You can use the linked cell of the combobox, and refer in the IF formula to that cell instead, but that depends on what type of combobox are you using, in other words, what toolbar did you use ?
 
Upvote 0

Forum statistics

Threads
1,213,544
Messages
6,114,249
Members
448,556
Latest member
peterhess2002

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top