VBA to generate sequential number

Hi, Guys!


Once more, asking for help!
I'd like that VBA generated a sequencial number based on inputs of users. For instance, I have the following sequencial catalog format:


Item-number-type-year


These are the following variables for item input:
Screw, flange, winch, crane, wheel, motor


And these for type input:
lay, top, bab, cat, lok, kip


For example this is the first item that I want to catalog, so it would be:
Screw-001-lay-2016


So if I enter screw(item) for lay (type) again VBA would create screw-002-lay-2016. If I created the same item for top, it would be screw-001-top-2016.


Note that all these variable are input by the user on a dialog box, except the Author name that should be copied for column B.


Could you guys help me achieving this?


Find the worksheet print and VBA.
Excel sheet:
http://postimg.org/image/lc1mlf3eh/

Please Login or Register  to view this content.

Thanks!

Sorry!

Vessel = item

Department = Type

So the only thing generated would be the number!

I did not get your another question, I'm learning step by step VBA codes.

Could you help me with that? Attached is the full excel sheet. I coud not upload it in here, so I uploaded it on my Google Drive.
https://drive.google.com/file/d/0B8q...ew?usp=sharing

Thnaks!

Thanks, Walruseggman! It is working as expected!!

Could you help with something else?

I want it to still counting + 1 if the Vessel input does not change. For example, no matter what input I make, if the vessel name is always the same, should be added +1 in the sequential number. Another thing, could you change for 3 digits the numbering? I tried to do it, but i did not success at all...

and last but not least... is that possible to copy only the first 3 letters from vessel input and department input? something like that, if i entry Topazio as vessel and technical as department, the sequential should be TOP-001-TEC-2016.

Once again, thanks a lot for your support!!

Anyone?

Thanks a lot walruseggman!

I was just wondering if it is possible to copy for column C date of IUR number generation and also copy department and vessel (not the shorten format, just the text as written in the userform box) to column D and E respective. One last thing, in the IUR box it is counting 002 for the first. I looked the code and it is couting blanks, could fix that and start couting from 2 row ahead? so that would count only the entries and not the titles as well. Thanks a lot again man!!