Generate unique numbers in serial

I am doing bank recon in excel
for every allocation i make between books and the bank statement i am marking a unique serial number for reference ..manually ..
can someone help me generate this automatically based on a click .. using vba code
Appreciate your immediate response