Emma

John McGimpsey show you how at this site.

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


Gord Dibben MS Excel MVP

On Fri, 22 Jun 2007 09:30:00 -0700, Emma Winskill
wrote:

Thanks Steve, but how to I utilise this formula on a command button? The
form I am creating is for use as a quotation so therefore is set up as a
template. So each time a new number is created it will be used as a quote
reference therefore will be unique to each file if you like.

thanks