Updating a list...

Hi Guys,

I currently using a portion of code (found here) to insert a record in a list.

The list has numbering down 1 column, and i want that numbering to be updated after i insert that new record. For example, if i insert row 2.1 in the list 1, 2, 3, 4. I want the updated list to be 1, 2, 2.1, 3, 4.

Thanks in advance for any help!

Hi Sixsense,

Here is an extract of the workbook. I've broken it down so its clear. Basically, when the user clicks 'Add', they fill out the 'Col x' details and enter a step number. I then want that record to be added to that list in the relevant position. This is all working fine.

The part im struggling with, is after the user adds that record, i want the 'StepNo' in Col A to update all values, so that they are still in the correct order.

I've added record 4 and 4.1 to show you an example of the problem. As you can see, adding 4 was fine. But then when i added 4.1 it inserted it above.

Hopefully this explains it a bit better.

And thanks for the swift response!

Here is the code behind the 'Add' button.

Please Login or Register  to view this content.

Anyone able to help?