Rather than search for new max number on initialisation I have put the code on a new button.
The reason for this is that on add new client the form clears including new number-with the seperate button it can be recalled at any time - there are no formula on the sheet now.
Also add DateValue to 3 items in the combobox search code.
No matter what you name your userform the UserForm initialization is always named just UserForm and will not be recognised as anything else.
Bookmarks