Hello Friends!
To illustrate my problem, i have created and attached 2 files.
These 2 files are linked and any change in one file (marital_status.xlsm) should cause the pivot tables in the other file (marital_status_report.xlsm) to refresh. This works fine. No issues here.
My problems started when i tried to create a notification message box, which tells the user about the change being made. The message box displays, but I am having trouble referencing the column headers.
Kindly open the two files, and make any change in the "marital_status.xlsm". When you read the message box, you will see the issue i am having.
Eagerly expecting your replies.
Last edited by byronova; 03-08-2010 at 08:03 AM.
Cells() takes arguments (row, column) - not (column, row).
try:
(middle line)Code:MsgBox "You Have Just Changed The " & Cells(1, Target.Column) & " Of " & Cells(Target.Row, 1)
hth
Dear Cheeky Charlie,
Thank you for your reply! works like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks