Hi I am new into vba programming.
I have found this thread useful for serial number generation:
www.mrexcel.com
My problem is that I have data validation incorporated into textbox update function to check for serial number duplication across multiple worksheets. The command from that post creates serial number based on the last entrance in the sheet. I would like to have a data validation incorporated into that command that checks all 3 sheets and is adding the next available number. The command is within userform initialize.
I have found this thread useful for serial number generation:
Need to generate Serial Numbers without duplicate on my userform upon initialize.
Hi! This is my first question on this forum so I will try to be clear and specific as possible. I know it can get frustrating when you guys have to give solutions of unclear questions.:p - My purpose · I have a database of patients, and a userform allows me to manage this database...
My problem is that I have data validation incorporated into textbox update function to check for serial number duplication across multiple worksheets. The command from that post creates serial number based on the last entrance in the sheet. I would like to have a data validation incorporated into that command that checks all 3 sheets and is adding the next available number. The command is within userform initialize.
