![]() ="CompanyName"&RANDBETWEEN(100000,999999)& D2įormula is too complicated to remember? Save the formula as an Auto Text entry for reusing with only one click in future! ="CompanyName"&TEXT(NOW(),"MMDDHHMMSS")& D2 In addition to make whole numbers as invoice number, we can verify our invoice numbers with following formulas: No. Note: Change the D2 to the specified cell in which you entered the beginning number of invoice number in Step 2.ĥ. VBA: Voice Number Generator Private Sub Workbook_Open() Paste the following code into the opening window. Note: In our case, we double click the ThisWorkbook under the VBAProject (Book1).Ĥ. Open the Microsoft Visual Basic for Applications dialog box with pressing the Alt + F11 keys simultaneously, then expand the VBAProject (current workbook), and double click the ThisWorkbook.
0 Comments
Leave a Reply. |