Generate and display unique AutoNo. in Excel Userform and link to worksheet.

Hi

Im new to VBA. I would like Userform to auto generate a unique number and every time the form is open, it automatically increases its number before even updating records or click any buttons. (example, CRUINT000001...CRUINT000002...)

This Auto generated number will then be auto added to coloumn A named "Ref" in the worksheet. Im not sure what tool to use, label, textbox or commandbutton. Please help

Below are the codes I've created so far.

Thanks
Lizah

Please Login or Register  to view this content.

Hi jraj,

Is there a way that the generated number be displayed on the Userform as well so that it is easily retrieve by other users instead of looking into the excel sheet itself?

Thanks