office spreadsheet 10.0

[abe6162]

I am using office spreadsheet 10.0 in an Access application. I am using the spreadsheet as a form for entrying in data, or correcting data already in the database.

After I upload all the data from the database into the spreadsheet, the user can change or insert new data in to the spreadsheet. What I would like to do is be able to identify all the changes in the spreadsheet by changing the interior color of the cell. In order for me to do this, I need to identify the cell address.

There is property in the spreadsheet for "on update", which will run after a user updates a cell. I can not however figure out how to retrieve the cell address after the update to change the interior color. Please help.

 

[PHV]

Doesn't have the Update event procedure a range parameter ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[sfm6s524]

The Worksheet Change event has a Range parameter. So if you really want to annoy your users, your WorkSheet_Change event could be:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Target.Interior.ColorIndex = 3
End Sub

Ken