Hi I have the VBA. Can i check if i want to change the target address B3 to another worksheet called Sheet1 and cell B3, how can i amend the code? The worksheet where the timestamp is on is called Report.
Please Login or Register to view this content.
you need to copy the entire code to Sheet1 so that the target will check the Sheet1> B3 range
Do like oluapseyer suggests; copy the code to the sheet1 code module. And then also add a reference to the Report sheet like below.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
Hi
When I tried that the data that was supposed to be recorded on the report tab like the username and timestamp got recorded on sheet 1.
check this portion of code. Maybe you havent reference it to the REPORT sheet just like what youve asked.Please Login or Register to view this content.
code came from AlphaFrog.
Hi I tried that as well and the code is not triggering. I must have missed something out. I have attached the file for your review.
Try restarting Excel. The code works for me, although I think you should be matching on column 2 on the Table sheet.
Don
Please remember to mark your thread 'Solved' when appropriate.
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
Thank you very much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks