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

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...

this give a unique number


Kind regards
Leo

Thanks to you also Leigh, very much appreciated

[SOLVED]

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