Event Macro help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ted Metro - 26 Mar 2008 04:29 GMT

I have this change macro and in o1 I have the cell link for a combo-box.
When a value is selected in the combo-box the number changes in o1, but it
does not trigger my event macro because I'm not changing the value it's
simply updating from the combo-box.

How can I write my event macro so that it will trigger from a user changing
a value in my combo-box?

Have a good day!

Ted

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count > 1 Then Exit Sub
On Error GoTo ErrHandler
If Not Intersect(Target, Range( _
"o1:o3, o1:o5")) Is Nothing Then
Application.EnableEvents = False
Range("h6:h10").Select
With Selection.Interior
.ColorIndex = 44
.Pattern = xlSolid
End With
End If
ErrHandler:
Application.EnableEvents = True
End Sub

Reply to this Message

JLGWhiz - 26 Mar 2008 04:47 GMT

Right click the combo box > View Code, and if it does not automatically
appear then click the declarations window and look for this:

Private Sub ComboBox1_Change()

End Sub

Put you code inside this and it will execute with each selection change.

> I have this change macro and in o1 I have the cell link for a combo-box.
> When a value is selected in the combo-box the number changes in o1, but it
[quoted text clipped - 23 lines]
> Application.EnableEvents = True
> End Sub

Reply to this Message

Ted Metro - 26 Mar 2008 16:14 GMT

Wow, that was too easy. Thanks!!

> Right click the combo box > View Code, and if it does not automatically
> appear then click the declarations window and look for this:
[quoted text clipped - 32 lines]
> > Application.EnableEvents = True
> > End Sub

Reply to this Message