G Guest May 2, 2006 #1 I need to have the form number on the form increment by 1 when the form is opened by another user on the system.
I need to have the form number on the form increment by 1 when the form is opened by another user on the system.
P pdgood May 2, 2006 #2 I'd like to know how to do this also if anyone would care to share their knowledge. I assume it would take VBA.
I'd like to know how to do this also if anyone would care to share their knowledge. I assume it would take VBA.
G Gord Dibben May 2, 2006 #3 Have a look at John McGimpsey's VBA method. http://www.mcgimpsey.com/excel/sequentialnums.html Gord Dibben MS Excel MVP I need to have the form number on the form increment by 1 when the form is opened by another user on the system. Click to expand... Gord Dibben MS Excel MVP
Have a look at John McGimpsey's VBA method. http://www.mcgimpsey.com/excel/sequentialnums.html Gord Dibben MS Excel MVP I need to have the form number on the form increment by 1 when the form is opened by another user on the system. Click to expand... Gord Dibben MS Excel MVP