Hi All,
I need a bit of help and I'm sure this is real easy. I want to create a command button that once pressed will increase a docket number range by one, but I'm not sure how to do this.
E.g NSW-0000000001A once the button is pressed I want to the docket number to become NSW-0000000002A and so on each time the button is selected.
Any advise or help you can give me will be greatly appreciated.
Darran
Always with 10 numerals? So once it gets to 10 it would be 0000000010?
Are the alphas constant? Always NSW and A?
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
Try this: Book1.xlsm
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks