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

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

On Thu, 25 Oct 2007 16:30:00 -0700, hmk311
wrote:

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

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

Regards,

"Gord Dibben" wrote:

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

On Thu, 25 Oct 2007 16:30:00 -0700, hmk311
wrote:

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

I provided two links and both work for me.

Which one does not open for you?


Gord

On Fri, 26 Oct 2007 03:27:02 -0700, VIVEKMANE
wrote:

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

Regards,

"Gord Dibben" wrote:

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

On Thu, 25 Oct 2007 16:30:00 -0700, hmk311
wrote:

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,

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

On Oct 27, 12:11 am, Gord Dibben <gorddibbATshawDOTca wrote:
I provided two links and both work for me.

Which one does not open for you?

Gord

On Fri, 26 Oct 2007 03:27:02 -0700, VIVEKMANE



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

Regards,

"Gord Dibben" wrote:

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

On Thu, 25 Oct 2007 16:30:00 -0700, hmk311
wrote:

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/...tialnums.html- Hide quoted text -

- Show quoted text -

OP provided that link in his original post.

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


Gord

On Fri, 26 Oct 2007 16:21:23 -0700, Pete_UK wrote:

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

On Oct 27, 12:11 am, Gord Dibben <gorddibbATshawDOTca wrote:
I provided two links and both work for me.

Which one does not open for you?

Gord

On Fri, 26 Oct 2007 03:27:02 -0700, VIVEKMANE



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

Regards,

"Gord Dibben" wrote:

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

On Thu, 25 Oct 2007 16:30:00 -0700, hmk311
wrote:

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 - Hide quoted text -

- Show quoted text -