Userform - integrating code from old form into new template, timestamp, ID No etc

Hi,

I'm trying to combine a form template (which has working back and forwards controls) with my functioning existing form. Some of the controls are not working however, mainly:

(1) The ID number in Column A - incrementally increasing by 1 -eg 1,2,3...

(2) The time stamp to appear in column B

My original functioning timestamp code (below) is inputting the timestamp into column C, but I would like for it to appear in Column B.

Please Login or Register  to view this content.

(3) the date column D is not displaying the selected calendar dates

(4) the original VLookup for employee name and employee no, and the department according to the team leader name.

Please Login or Register  to view this content.

If even if only one of these issues can be fixed I'd appreciate it.

By the way, this is where I've got the template from: http://www.myonlinetraininghub.com/e...t-update-delet

Thanks

Please Login or Register  to view this content.

I would have thought issue 1 was resolved too.

I tried stepping through your code and believe me it is horrendous.

If you have a lot of worksheet Specific macros then you need to be a bit cuter when you make changes to your worksheet.

Presently your macro makes a change
Which kicks of a sheet specific macro
Which makes a change
Which kicks of a sheet specific macro
Which makes a change ad infinitum.


So you need to control what macros are started when your macro is running.

Use

Please Login or Register  to view this content.

To stop macros being kicked off

Please Login or Register  to view this content.

To restart Macros.