Quote:
#2 - I don't really see why you use that loop when adding. Does it not just get added to the end? If it could get inserted, you could use Application.Match to get its position more quickly than looping.
In thinking about this, I've named the range in Column A as GHMS ($A$2:$A$9999). Since this will never need to be amended, I'll not need an insert function. However cells within the other 2 columns (Named Ranges- "Rego" and "Owner"), may display blanks, which may need to be edited when a driver presents physical evidence of a GHMS valid ticket.
Quote:
#4 - I think you should think abouts interface as well as its functionality. The form is over-large, and would benefit from reducing and laying out nice and clearly. I always think an image on a form when it is the only one also makes it look better.
The problem I have here is that this form is the only interface that the User gets to see. If I shrink the form , what do i use as a surrounding background?
Quote:
#5 - when showing a list of ids, it is often a good idea to have a multi-column list and show the basic details of the item in the row as well. It won't bother people who know the ids and can work with them, it will help people who are no so familiar with them
I could fill the bottom section of the form with text, namely a help assist set of messages I guess, so that the user can understand that which we are asking her to do if certain situations occur.