Thank you for this great VOD, I worked with this on a PC excel and application.username returns the user name. but when I open this same xls on mac I get generic Microsoft Office user. I tried using Environ ("USR") which returns My login id. but that same environ does return the same this on PC. is there a way to write the code so it know a difference between a mac and PC. Help Please.
What code is required please when you want to show a comment only with selected columns, like "A1: A250", "C1:250 ", "F1:250" & "J1:250". Not all columns and rows. Thanks
Hi, is there a way to add a dynamic comment when I select a cell? for example if I click on a cell with a date it will temporarely have acomment with the day of the week
@@EverydayVBAExcelTraining i have a database in sheet one, and in 2nd sheet i done consolidated, in the consolidated sheet if i take mouse pointer particular cell comment box will popup, in that if example 10 employees are there in x department all the particular department employees names should auto update when i change in sheet 1.
Thanks for your prompt response. When i apply it, the "for each in target" is error, and i change to " for each in rng", however, the exiting cell commend will add one more time for each time a cell edited. Can you please advice how to fix it? thanks.
I tried that, after edit any cell in the range, the code "Elseif Not c.comment is nothing...." will run for all cells. Then all cells comment will add a new with current information in cell (did nothing with the cells), how to limit it run in the cell in editing?
Are you trying to get the value in the cell prior to deleting it? Or are you just wanting to know when a deletion happens? Can you paste your code and I can take a look
@@EverydayVBAExcelTraining thank you. i am just getting a blank comment with user name when deleting cell value. but when i change value, it is not recorded as in video.
Thanks a lot sir,It's really helpful to me.I wanted this vba formula.God bless you.
Sweet example.for keeping track of value changes and who did them. I might also add date and time.
how do you add date & time
Thank you for this great VOD
Thank you
Great job, thanks for sharing the knowledge, just what I needed. Keep up the great work boss!
Thanks brother ,
If i have to record comment in 6 columns only not for the entire sheet then how to change this code
wonderful coding ,great idea
Спасибо дружище
Great idea!
Glad you think so!
Can I apply to all sheets in the workbook?
Thank you for this great VOD, I worked with this on a PC excel and application.username returns the user name. but when I open this same xls on mac I get generic Microsoft Office user. I tried using Environ ("USR") which returns My login id. but that same environ does return the same this on PC. is there a way to write the code so it know a difference between a mac and PC.
Help Please.
What code is required please when you want to show a comment only with selected columns, like "A1: A250", "C1:250 ", "F1:250" & "J1:250". Not all columns and rows. Thanks
You have us the target.address or target row.
With and if statement
@@EverydayVBAExcelTraining Thank you. I have used the Target, Intersect and specified the range .
thank you very much , very useful, to follow up task
Thanks for the feedback
Hi, is there a way to add a dynamic comment when I select a cell? for example if I click on a cell with a date it will temporarely have acomment with the day of the week
You would nees to use on_change.
So when a cell is changed you would need to read the target cell value and then insert info into the comment
thank you! I'll try it
is there any possibility to update data which is existing in excel sheet, it should auto update in comment box as well
Yes that is doable but would be hard to explain here without fully know what you were trying to do
@@EverydayVBAExcelTraining i have a database in sheet one, and in 2nd sheet i done consolidated, in the consolidated sheet if i take mouse pointer particular cell comment box will popup, in that if example 10 employees are there in x department all the particular department employees names should auto update when i change in sheet 1.
how about adding a timestamp + the application user?
It would probably look like
Application.user & "-" & now
Can the comment box list original content and new content
Hi there, how can I set the range is C4:k1000? Thanks.
+Ryan wu
Dim rng as range
Set rng = range ("c4:k1000")
Thanks for your prompt response. When i apply it, the "for each in target" is error, and i change to " for each in rng", however, the exiting cell commend will add one more time for each time a cell edited. Can you please advice how to fix it? thanks.
it would most it would need to be
for each cl in rng.cells OR for each cl in rng
let me know if that helps
I tried that, after edit any cell in the range, the code "Elseif Not c.comment is nothing...." will run for all cells. Then all cells comment will add a new with current information in cell (did nothing with the cells), how to limit it run in the cell in editing?
@@ryan21370 Did you ever solve this?? I Have the same problem
Need help. comment is added only when deleting a cell. i am using excel 2016.
You would use the on change event
Where target.value = ""
The challenge is figuring out what it was prior to deletion
@@EverydayVBAExcelTraining Thanks for your quick response. but i am novice in VBA so i could not get what you said. kindly elaborate.
Are you trying to get the value in the cell prior to deleting it?
Or are you just wanting to know when a deletion happens?
Can you paste your code and I can take a look
@@EverydayVBAExcelTraining thank you. i am just getting a blank comment with user name when deleting cell value. but when i change value, it is not recorded as in video.
i am using the code you provided in description.
👍