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.
Bookmarks