Form Numbers Automatically Increment by 1 Upon Opening
 

I need to have the form number on the form increment by 1 when the form is
opened by another user on the system.

Form Numbers Automatically Increment by 1 Upon Opening
 

I'd like to know how to do this also if anyone would care to share their
knowledge. I assume it would take VBA.


--
pdgood
------------------------------------------------------------------------
pdgood's Profile: http://www.excelforum.com/member.php...o&userid=31623
View this thread: http://www.excelforum.com/showthread...hreadid=538181

Form Numbers Automatically Increment by 1 Upon Opening
 

Have a look at John McGimpsey's VBA method.

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


Gord Dibben MS Excel MVP


On Tue, 2 May 2006 11:51:02 -0700, GVDLS
wrote:

I need to have the form number on the form increment by 1 when the form is
opened by another user on the system.

Gord Dibben MS Excel MVP