View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default Urgent Help, Comboboxes and IF.

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