Quick question.

Say i have a combobox with 5 answers in, 1 2 3 4 and 5.

Is there anyway to get this information into and IF command.

I need Cell F11 to run the macro 'Correct' if the answer is 4 or run
the macro 'Incorrect' if it is 1 2 3 or 5.

Urgent reply needed, thanks alot.

Rob.


--
R.Chapman
------------------------------------------------------------------------
R.Chapman's Profile: http://www.excelforum.com/member.php...o&userid=31631
View this thread: http://www.excelforum.com/showthread...hreadid=513236

The following worksheet event macro should do:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Address = "$D$2" Then
If Range("D2") = 4 Then
Call Correct
Else
Call Incorrect
Endif
Endif
End Sub

We assume that the combo box is linked to cell D2 in this worksheet. To
include,
Right-Click on the sheet tab, select View Code and paste the code. Once
you are in this module you can go to the top of the code window and see
which other events can be handled with event procedures.

HTH
Kostis Vezerides