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

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