MrExcel Publishing
Your One Stop for Excel Tips & Solutions

OnEntry property

Posted by Caffeine_Kid on September 17, 2001 6:17 PM

I've looked and looked for a website that has the code for what I need but none seem to exist and I'm going nuts trying to figure it out. I need to check to see if a range of cells change d9:d16 however i'm not sure how to test them. I can get the on entry to work if I dont specify a range of cells also. if the values change I call out to another function however that function is Combobox1_Click as I'm re generating a chart (pasting from another section) by using the dropdown boxes. I need The boxes cause they tell what chart and formulas to use. Currently I have it working but I've had to redo the case statements to look to a cell that I have linked to each comboboxes variable...any help would be appericated...thank you in advance

Posted by Jaime on September 17, 2001 8:24 PM

This works for me, but maybe I did not get ur question.

Private Sub Worksheet_Change(ByVal Target As Range)
If (Target.Row >= 1 And Target.Row <= 5) And Target.Column = 1 Then
Cells(5, 5) = Rnd
End If
End Sub

This is the Change Event procedure of the worksheet.
Here I trigger the event if any value on range(a1:a5) changes.