Autonumbering

[Guest]

I have been searching for a way to have excel autonumber my work orders. I
have come across this link several times. Problem is, I don't know how to
use that information. Can someone explain this to a beginner?

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

 

[Gord Dibben]

JE explains it as well as anybody but maybe what you are confused about is where
to place the varying sets of code.

All code except for Private Sub Workbook_Open() will go into a general or
standard module.

As JE points out, the Private Sub Workbook_Open() will go into Thisworkbook
module.

Depending upon which approach you take, there could be two of those.

For getting started with macros and VBA see David McRitchie's site.

http://www.mvps.org/dmcritchie/excel/getstarted.htm

And Ron de Bruin's site for where to place codes.

http://www.rondebruin.nl/code.htm


Gord Dibben MS Excel MVP

 

[Guest]

Dear Gord Dibben,
I cannot open the link which u have provided,
kindly explain..

Regards,

 

[Gord Dibben]

I provided two links and both work for me.

Which one does not open for you?


Gord

 

[Pete_UK]

Gord,

I think it was this one:

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

You didn't provide it directly, but it was in the hidden post from the
OP.

Pete

 

[Gord Dibben]

OP provided that link in his original post.

Obviously he had been there because he said he didn't understand John's code.


Gord