I am currently working on a spreadsheet application. I am almost complete but I am stumped on performing the following. Maybe someone more knowledgable on VBA could help me.
I have a button which is titled Insert Task ... When the user clicks the insert task a row appears below with 2 cells filled in on XX1 and XX2. A1 contains the autonumbering 1 and A2 contains the text New Task. Now I have managed to code it so it will number ONLY if the user does this is sequence. Unfortunately I have another button "Insert Sub Task" which inserts a row with cells XX2 and XX3. Which contain 1.1 New Subtask or 1.2 New Subtask ... depending on the previously inserted TASK.
Is there any viable way to perform this type of numbering/bulleting using any type of code?
Thanks!
B