I am trying to make a job ticket in Excel I have it laid out but I need to set up a macro that alwos me to have a job tcket number in one field change by 1 number every time I activate the macro.
for Ex: I have a field set as job ticket number it starts at 100 then when I go to make a new job I press the "ctrl+j" for job ticket nad the number changes to 101.
Is this possible and how would i go about setting it up Any help would be appreciated.
Thanks

Excel question
donJulio
This is not a VSTO-related, but a good macro question that you should post in the excel.programming newsgroup. Here is the link:
http://msdn.microsoft.com/newsgroups/default.aspx dg=microsoft.public.excel.programming&lang=en&cr=US
Thanks!
Mike Hernandez
Community Program Manager
VSTO Team