Thread: Form Numbers Automatically Increment by 1 Upon Opening
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote