Inserting columns ruins fill in form

Hi All,

I use the following code for a fill in form to add data.

Please Login or Register  to view this content.

This works fine until I insert a new column and unlike most things in excel the form does not realize and compensate for the new column. Is there any way for VBA to account for adding new columns?

Thanks

Hi,

Thanks for the reply.

As requested I have made a temp file to assist.

Thanks for the great support.

Hi Marvin,

I am not that good at coding so am not really sure what you did however.....

I opened the file and run the form to update details and it worked fine but then I added a column between AI and AJ which moved AJ to AK. Then I tried the update driver details again and it did not realise that what was in col AJ is now AK so when I put some information in the fill in form in "Date of Licence Check" it placed this data in AJ (the new col I inserted) not AK as it is now know.

I hope I am explained this correctly, just to summerise the fill in form worked fine as it was but it did not allow me to insert extr columns of even move colums around as the fill in form is column fixed if you get my meaning.

Thanks for the help.

Is there any further advice that can be given on this?

Thanks