ExcelBanter - View Single Post - Data form not triggering Worksheet_Change event

Bret Bernever

In article ,
says...

so I'm afraid I don't know the answer to your
problem. Apologies.

No problem at all. Appreciate you just gave it a try. Tried the
worksheet_calculate also, but it didn't pull the trick. I made a dummy
field where a value was adjusted after I inserted a new record with the
data form. No success!

Could you post your code?

Well that's not important here. I have a range with data and after
choosing Data - Form... from the menu, excel shows the form. After
inserting a new record the worksheet_change event should trigger and
perform some VLookUp operation like:

******
Private Sub Worksheet_Change(ByVal Target As Range)
strAddress = Application.VLookup(Me.Textbox1.Text, rngCodes, 3, False)
end sub
******

I'm just interested in tackling this problem.

Kind regards
Bert