Auto Change Notification

K

Kanmi

I have a Workbook link to the database, Anytime changes made in the database
and when i open the workbook then there are Automatic update on the
worksheet."sheet1" I'm looking for a way to be able to know the new changes
either by changing font, colour or any other ways to know this is new data
added to the pages or editing. For example


First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 Manager
Larry Lus 002 01/20/2009 Supervisor
Colls Ref 003 02/02/2009 Sales Rep

IF MANAGER
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 Manager

(CHANGE) TO MD
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 MD

AND NEW STAFFN WAS ADDED
First Name Last Name ID Hire Date Title
Jeff Dell 001 06/25/2009 MD
Larry Lus 002 01/20/2009 Supervisor
Colls Ref 003 02/02/2009 Sales Rep
HUB CLINTON 004 07/12/2010 General Manager.

I want know these changes by showing/appear different from the rest of the
data. Please can anybody help me. Thanks and Appreciate your time.
 
P

Patrick Molloy

you can use the Change event of the worksheet to embolden the text and
change the background color

for example, right click on the sheet tab and select View Code from the
pop-up then paste the following code:-

Option Explicit
Const cTan As Long = 10079487
Private Sub Worksheet_Change(ByVal Target As Range)
With Target
.Interior.Color = cTan
.Font.Bold = True
End With
End Sub

This will color the changed cells and make the font bold
 
K

Kanmi

ERROR: "Microsoft (ODBC Excel Driver) Too few parameters. expected 2". This
pop up when i try to refresh data. Please advice on what to do. Thanks
 
K

Kanmi

Okay now. I was able to solve the previous error. This code is not working
yet. This sheet is link to another page when i right click and click on
REFRESH DATA then it will run automatic update then it should show bold and
colour to those changes it pulled from the database. please help. Thanks and
Appreciate your time
 
E

EricG

I tried this on one of my workbooks that pulls metrics from a big Access
database onto one of the Excel worksheets. The change event triggered only
once - at the end of the data refresh - and change the color of the ENTIRE
set of data to tan. Apparently the change event thinks that the whole
current region of the sheet changed or something like that? The Target was
the entire range of data being pulled from Access, not just any cells that
had changed value.

Any suggestions on how to get around that?

Eric
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top