When value appears adjacent cell acknowledges

Hello,

I am looking for some VBA code that looks at a column in my worksheet called "Database" and when a value appears in this column, I would like the cell adjacent to it to record a number. For example:

B1 = 001
C1 = Example

When anything appears in Column C:
C2 = Jimmy

I would like B2 to say 002.

When anthing appears in C3:
C3 = Fred

I would like B3 to say 003.

...and so on.


I can do this in an excel worksheet but can't figure out the code for VBA.

Any suggestions would be much appreciated.