Check your spelling. The Else part will only execute if the first part is
not true.


"Silvio" wrote in message
...
Hi Ryan, I am not sure if I am missing something but regardless of my
selection from the combo boix the "else" condition always fires up even
though "test1"was selected. Any idea?



"Ryan H" wrote:

Assuming you named your Combobox MyComboBox this should work for you.
Put
this code into the ComboBox_Change Event. This will fire each time
someone
changes the combobox value. Hope this helps! If so, let me know, click
"YES" below.

Private Sub MyComboBox_Change()

If MyComboBox = "test1" Then
Range("B1").Formula = "=Sheet2!A1"
Else
Range("B1").Value = ""
MsgBox "B1 has no data source.", vbInformation
End If

End Sub
--
Cheers,
Ryan


"Silvio" wrote:

Hello, I would like to change a cell source base once a selection made
from a
combo box. After making a selection from the combo box the code should
do
something like:

If MyComboBox = "test1" then
B1 = Sheet2!A1
Else
B1 has no data source (null)
End if

What's the easiest way to accomplish my goal in Excel 2007?
PS. B1 is the cell in my fist Sheet.

Thank you,
Silvio