Userform ListBox within range to add addition row within a range restriction

Good day,
I was fortunate to receive help to continue my work but now got stuck and can’t seem to add the “Insert New row” or where to add or maybe I’m not even doing it right.

I have a worksheet with 4 column and need to only function in these columns as I have information doing something else.
In Column A, B, C and D are my main column for the following functions:

Column A will act as titles
Column B will act as sub titles (There can be multiple sub titles withing the same title, needs to be added on an as when requirement)
Column C will act as possition (There can be multiple position withing the same sub Title, needs to be added on an as when requirement)
Column D will act as sub position (There can be multiple sub position withing the same Position, needs to be added on an as when requirement)

All columns will react to what is in Column A. I have the following code for column A:

Please Login or Register  to view this content.

This will look in my next available row to see if it is a blank row then add my information from my userform listbox.

I have tried to add the same procedure to my column B but don’t even come close to what I need in this function.

I need that when I double click my sheets cell in accordance to the following code:

Please Login or Register  to view this content.

...to show my userform then to add the information but only to look in Column A to D and not pass this column.

I have added a Workbook to add the other information has it could get long to actually explain but to quickly explain:

I will need to add a title (already set up with a userform, listbox and on click of this listbox it will transfer the information to my sheet) This will look in my Column A to see where is my next available blank row and add the listbox value to it. If I double click column B, next to the columns A title, I need to add this information on the next available blank row but to create a Insert new row as there could be addition information going in column A or B and so on... I presume it will be the same code for C and D as this has to function the same way.

See Attachment for details and information.


Book1.xlsm