Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change Notification
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change Notification
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 "Kanmi" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change Notification
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 "Patrick Molloy" wrote: 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 "Kanmi" wrote in message ... 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. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change Notification
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 "Patrick Molloy" wrote: 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 "Kanmi" wrote in message ... 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. |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Change Notification
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 "Patrick Molloy" wrote: 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 "Kanmi" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change me e-mail notification address in MS Newsgroup ? | Excel Discussion (Misc queries) | |||
Microsoft Outlook notification on Excel change | Excel Discussion (Misc queries) | |||
Amending a Document and Sending an Auto Notification | Excel Discussion (Misc queries) | |||
File Change Notification | Excel Programming | |||
Help, experts needed! Auto notification | Excel Discussion (Misc queries) |