Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

**nex2022** · 12-16-2014, 09:48 AM

Hi, i'm new to using VBAs so i'm not sure what to usually post things under whether under "ThisWorkBook" or under "Module". So please be precise. I want to capture saves, prints, open and Deleting and Adding of rows.

I have everything covered except the capturing of adding and deleting of rows. The following is what i have put under "ThisWorkbook":

Please Login or Register  to view this content.

The outcome is on a spreadsheet called LOG and looks like this:

Event User Name Domain Computer Date and Time
Save ammonia HRRH SRES005 04/12/2014 10:06

All i need now is for it to capture the adding and deleting of rows. Please help me with this and let me know exactly where to add what "ThisWorkbook" or "Module1"

**LJMetzger** · 12-16-2014, 09:49 PM

Hi nex2022 and welcome to ExcelForum.com,

See the first answer in the following thread which seems to be an excellent implementation of your add/delete problem. However it needs a 'Named Range' on each sheet to identify whether there was an addition or a deletion. http://stackoverflow.com/questions/7...-deleting-rows

Lewis

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**nex2022** · 12-17-2014, 10:57 AM

Hi Lewis thank you for the reply. As i am still new to this where do i post the code from that thread? (under module or the tab itself that i want tracked? because i do only want one tab tracked not the rest)

This is what the other thread suggests: And what do you mean by a date name range and what does "RowMaker" mean what am I suppose to replace it with (tab name?)

Please Login or Register  to view this content.

**LJMetzger** · 12-17-2014, 05:48 PM

The sample code worked but was incomplete, because the value of the 'last row' had to be initialized. Otherwise, the first addition or deletion would not have been recognized. See the attached file that contains the following code:

This Workbook module - for initialization:

Please Login or Register  to view this content.

Sheet1 module:

Please Login or Register  to view this content.

Lewis

**Leith Ross** · 12-17-2014, 07:42 PM

Hello nex202,

Welcome to the Forum!

As a new member of the forum, I have added Code Tags to your posts. This makes it easier to see what you have written in the post and what is code. It is also easier for others to copy your code for testing.

Click here to learn about formatting tags

**nex2022** · 12-18-2014, 10:06 AM

Task List - Copy.xlsm

Hey Lewis,

That's amazing of what you did! it works perfect but is there a way to have that message box changed from that to just being input on a spreadsheet thats hidden.

I've attached what file i'm working on. if you go to the developer tab and run the macro "viewlog" and if you highlight everthing you can see that it tracks what computer name and user name committed the action. I have save, open and print figured out and now you have figure out the add/delete rows section. how can I add that to my already VBA code. I hope you can be of further help as you have been most helpful and i'm learning lots from it too

**LJMetzger** · 12-18-2014, 11:48 AM

Hi,

Nice worksheet design.

See the attached file. You will have to copy the code from my file to yours, since my Excel 2003 loses some of the features (e.g. colors, controls, etc) that are not available in Excel 2003.

The NAMED RANGE is now automatically defined/modified when you open the workbook.

ThisWorkBook Module (changes in red):

Please Login or Register  to view this content.

Sheet1 Module (Summary Sheet) - all code is new:

Please Login or Register  to view this content.

Lewis

**nex2022** · 12-18-2014, 12:01 PM

Hey Lewis,

Thank you so much!!! Finally something that's complete and could track if people aren't following instructions!!!!!!! This is gonna save me and give me people that can't follow simple instructions!!! Thanks again Lewis and greatly appreciated!

Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

LinkBack

Thread Tools

Rate This Thread

Display

Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Re: Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Re: Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Re: Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Re: Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Re: Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Re: Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Re: Excel VBA HELP needed! Capturing Adding and Deleting of Rows on spreadsheet.

Thread Information

Users Browsing this Thread

Similar Threads

excel 2003, help needed in deleting or displaying rows based on cell content one by one

Macro needed for capturing data corresponding to empty rows

Comapring two excel worksheets and adding or deleting rows as needed

VBA / Macro Conditional -> Adding rows and capturing data

Adding and Deleting rows - update formulas help needed.

Bookmarks

Bookmarks

Posting Permissions