Excel - VBA Form - populate worksheet table with auto increment ID, worksheet headers only

[EKExcel]

Hello All,

Please be kind, I have only started using VBA code in Excel in the last week . I have some experience with Access, but it is very different.

I need to produce an excel template that will have a dashboard worksheet containing buttons linking to various VBA data entry forms which in turn populate tables in other worksheets. I need this to be issued as a blank template once finalised, so no data can exist in the tables but the forms still need to work.

Screenshot 2015-11-13 12.56.04.png

The problem I have encountered in the attached example is when trying to enter a new asset, I cannot get the AssetID field to populate automatically. I have tried numerous codes found from all across the web, but nothing has worked so I am not evening going to show what I have tried. There is other code present, but that is for other functions such as adding the manually entered text to the tables, closing the form etc. I believe I have the code correct to insert the Asset ID into the table when it is created, I just have problems generating the incremental Asset ID.

PS - please excuse my messy code, at this point I am totally focusing on getting it to work rather than cleanliness...

[LeoTaxi]

this give a unique number


Kind regards
Leo

[Leith Ross]

Hello EKExcel,

Welcome to the Forum!

Here is the complete code for USerForm1. I have shortened the code a bit.

The AssetID number is on the "Dashboard" worksheet behind the "Stakeholders" button in cell C10.

Please Login or Register  to view this content.

[EKExcel]

Thank you very much Leo!! This is perfect

[SOLVED]

[EKExcel]

Thanks to you also Leigh, very much appreciated

[SOLVED]

[sktneer]

Please mark your thread as Solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.

[EKExcel]

Thanks sktneer, it's my first post on the forum and still finding where everything is...