Hi Guys
I hope someone can help me. I have an input Box that ultimately creates a new line of data on a Sheet. This works fine. However every time this form is activated I need to display the "next available" index number in the first box on the form. The index numbers are listed on a sheet called "DataSource" at Range("L2:L500"). I guess that once a number is used I would have to set some kind of flag to indicate it can't be used again. If I knew the code I could place this in the code for the "Save & Exit" Button. Any help with suitable code for the allocation of (and cancellation of) the next number and would be appreciated by this relatively Amateur VBA user.
Regards
BallGazer
I hope someone can help me. I have an input Box that ultimately creates a new line of data on a Sheet. This works fine. However every time this form is activated I need to display the "next available" index number in the first box on the form. The index numbers are listed on a sheet called "DataSource" at Range("L2:L500"). I guess that once a number is used I would have to set some kind of flag to indicate it can't be used again. If I knew the code I could place this in the code for the "Save & Exit" Button. Any help with suitable code for the allocation of (and cancellation of) the next number and would be appreciated by this relatively Amateur VBA user.
Regards
BallGazer