How to find if something has been changed on a worksheet..

[Prasad Vanka]

Hi,

I have a worksheet "UnprocessedPayments". It is populated with some
unprocessed payment records as some fields (columns) are in error. In
addition to the fields in error, the sheet also has suggested values
to the fields in error.

I have provided the user with two command buttons "UpdateSheet" and
"ProceedTOUpload". The user can either agree with the suggested values
or he can provide his own values in the suggested fields. When the
"UpdateSheet" command button is pressed all the suggested/userchanged
values will overwrite the fields in error. The the user sj=hould press
the "ProceedTOUpload" command button to process the payments.

The above works fine. What I want is that when the user presses the
"ProceedTOUpload" button without pressing "UploadSheet" then the
system should display an error message that the "UpdateSheet" needs to
be pressed.

Also one more question. If we have a command button in a user form and
we click it then it directly goes to the code window into
command_click event. But why does it not happen with a comman button
on a sheet. Also the code page for the sheet has only General and
Worksheet sections. Why doesn't it identify any controls on it. I had
to assign a macro to these command button to work.

 

[Pete McCosh]

Prasad,

1. One way round this would be to have a value assigned to
a cell (possibly on a hidden sheet) on completion of the
first macro, which you could then check at the start of
the second macro.

2. There are two different types of command buttons. You
have obvioulsy used the one from the "Forms" toolbar which
acts just as you describe, with a macro having to be
assigned to it.
If you use the control button from the "Controls
Toolbox" toolbar instead, it will appear in the Worksheet
module as an object with it's own programmable events,
properties window and so forth.

Cheers, Pete.