I am writing a program that uses a ticket number that will need to ad
to itself each time a button is clicked. I have wrote this small cod
to do so however each time I close and open the program the ticke
number goes back to 1. Please help any direction will be great.
thanks.
Mik

--
mikesr2
-----------------------------------------------------------------------
mikesr20's Profile: http://www.excelforum.com/member.php...fo&userid=2995
View this thread: http://www.excelforum.com/showthread.php?threadid=49658

Please post the code....
Anything in Workbook_Open , Worksheet_Activate or ...??

"mikesr20" skrev i
melding ...

I am writing a program that uses a ticket number that will need to add
to itself each time a button is clicked. I have wrote this small code
to do so however each time I close and open the program the ticket
number goes back to 1. Please help any direction will be great.
thanks.
Mike


--
mikesr20
------------------------------------------------------------------------
mikesr20's Profile:
http://www.excelforum.com/member.php...o&userid=29959
View this thread: http://www.excelforum.com/showthread...hreadid=496585

here is the code.

Function accumulate(n)
Static sum
sum = sum + n
accumulate = sum
End Function

it then outputs the value into a cell in excel

thanks


--
mikesr20
------------------------------------------------------------------------
mikesr20's Profile: http://www.excelforum.com/member.php...o&userid=29959
View this thread: http://www.excelforum.com/showthread...hreadid=496585

Any help??

--
mikesr2
-----------------------------------------------------------------------
mikesr20's Profile: http://www.excelforum.com/member.php...fo&userid=2995
View this thread: http://www.excelforum.com/showthread.php?threadid=49658