auto close

[rajagopal]

When the user reaches the end of selected range, the file will pop up a information that you've reached the end stage.
It should ask for confirmation whether the file can be closed or not?

[Bob Phillips]

What determines 'reaching the end of a selected range'?

[rajagopal]

Cell D72 is the last cell that the user can update.
So, once the user updates this field, the popup confirmation should come?
See the attached file for ref.

[Bob Phillips]

What if they go to D72 and update that before they update any others?

[rajagopal]

Is there any other option available to activate this function only when the user updates the file in a sequence like A1 to D70.

[Veekay2007]

There is not need to check the sequence rather you can use the follow algo:

If CurrentCell = D70 Then
Check previous cells for data presence
if data present then
... write code here to move to next step
else
prompt the user to finish the data entry
by taking him to the last empty cell
end if
end if

HTH

Veekay