| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Incrementing a receipt number in Excel 2003 VB form
Hi,
Can any one tell me how to do the simple task of having a receipt number increment automatically in VB code? I thought that it was as easy as something like: ReceiptNo = ReceiptNo + 1 Where ReceiptNo is the name of the range where the number is to appear. However this does not seem to work! Help would be appreciated. Tom |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Incrementing a receipt number in Excel 2003 VB form
Tom,
If ReceiptNo is a named range, use code like Range("ReceiptNo").Value = Range("ReceiptNo").Value + 1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi, Can any one tell me how to do the simple task of having a receipt number increment automatically in VB code? I thought that it was as easy as something like: ReceiptNo = ReceiptNo + 1 Where ReceiptNo is the name of the range where the number is to appear. However this does not seem to work! Help would be appreciated. Tom |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Incrementing a receipt number in Excel 2003 VB form
Chip,
Thank you very much, I was nearly there but did not quite make it. It now works fine. .......Tom -----Original Message----- Tom, If ReceiptNo is a named range, use code like Range("ReceiptNo").Value = Range("ReceiptNo").Value + 1 -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Tom" wrote in message ... Hi, Can any one tell me how to do the simple task of having a receipt number increment automatically in VB code? I thought that it was as easy as something like: ReceiptNo = ReceiptNo + 1 Where ReceiptNo is the name of the range where the number is to appear. However this does not seem to work! Help would be appreciated. Tom . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to make a receipt or invoice so that the receipt Nos. change automatically | Excel Discussion (Misc queries) | |||
| How do I get 2003 Macros and Toolbar Buttons form Excel 2003 to 20 | New Users to Excel | |||
| Donation receipt form | Excel Worksheet Functions | |||
| Incrementing a form | Excel Discussion (Misc queries) | |||
| Finding last receipt number in a column ? | Excel Worksheet Functions | |||
Hybrid Mode
