Hello,
I have been using VBA/Excel for a few days now and now I have come across a weird situation.
Please view the following VBA code which is executed after updating a combo box made from data validation method:
Private Sub Worksheet_Change(ByVal Target As Range)
Dim s As String
Dim c As Long
Dim r As Long
Dim retRowVal As Integer
c = ActiveCell.Column
r = ActiveCell.Row
If Target.Address = Cells(r, c).Address Then 'Comes from >>> If Target.Address = Range("G3").Address Then
s = Target.Value
Call Pin_IO_Assignmets(r, c, s) ' <<<LINE A
Else
retRowVal = Find_Block_Stamp_From_Anywhere(r, c) '<<< LINE B
End If
End Sub
Above I put two break points one on LINE A and one on line B. My question is, how can this be that when I single step from LINE A the program jumps to LINE B ???
This doesn't make sense as it should jump to the "End Sub" Line !!!!
Frustrated and confused.... can someone please get back with some help as to why this bazar behavior is happening.
Thanks again for any help
Much appreciated
Bookmarks