Double click to insert new row, only on specific cells (They all say "Add Line")

Good day all.

I am working on a spreadsheet which will enable me to track where my built systems are, and am hoping to make it a bit more user-friendly for future users.

In the attached file there is a table. Column A has the Product type, column B has the product name (each of the products will have a unique identifier), columns C and D are the versions of hardware and software, column E will change each time, and column F (location to track product) is manually edited.

What I am hoping to achieve is the ability to add a line if someone clicks the 'Add Line' cells which are in column A. I have seen a few examples where people add a row above a specific cell, and I tried to edit it so that it would occur to the 'active cell' and that it would be started by a double click, but have had no such luck. My issue is that this is my first time attempting anything with VBA, and I don't have much of a programming background at all. It's been quite fun so far, though, so I am looking forward to learning more!

I have got my pseudo code to assist any willing to help:

// User input:
// Double Click
//
// VBA actions:
// Check if cell has "Add Line" in it.
// If it does:
// Select active cell,
// Insert row above active cell,
// Copy format from line above inserted row into new row (including the Thing numbers (T1, T2) which increment, and the cell colour).
//
// If it does not:
// Ignore.

Thank you in advance!
Chris.

Hi Banaanas,

Thank you very much for your reply! Your code does exactly what I asked, which is probably where I went wrong haha

The overall function is perfect, so thank you for that. Is there anyway, though, to not increment columns A, C, D, E, and F. i.e. Only increment column B?

Sorry to be a pain!

Thank you again.

Again, thank you very much. Your help has been greatly appreciated

Hopefully one day I can repay the favour!

Chris