Dear macropod,
Thanks for the help. This works well for me!
As mentioned earlier, I have 3 tables which I have already bookmarked the tables of interest as Tbl1, Tbl2, Tbl3. Each of these tables have 3 columns and 1 row. At the last column/last row/last cell, instead of one content control, I have multiple content controls, where the last content control (bottom most) is named as "Resolve Date".
As such, when the user is prompted to add a new row, in the new row itself, the bookmark location will be shifted (it will not be in the exact spot “Resolve Date” as in the first row that I want it to be) and the user will be prompted to enter new row again at multiple content controls, not at the content control named as “Resolve Date”.
I have sought Mr Gregory's opinion on this and he has kindly advised me to modify my code to look for a specific tag/name upon ContentControl on Enter.
I tried to incorporate another conditional if statement as follows:
If CCtrl.Title = "Resolve Date" Then
If MsgBox("Add new row?", vbQuestion + vbYesNo) <> vbYes Then Exit Sub
End If
However this does not work. Are you able to advise how I should modify my code pls?
Thanks.
|