atmospheric
Well-known Member
- Joined
- Jul 16, 2002
- Messages
- 565
Ok, back to this first Userform of mine:
I am converting a data entry spreadsheet into a Userform for ease of entry. On the spreadsheet I have to following formula, (courtesy of Yogi Anand):
=IF(A5>0,LEFT(B4,4)&RIGHT(B4,4)+1,"")
This looks at the cell above and adds 1 to the numeric part, if the cell to the left contains something (a date in this case). The cell above contains an Order No in the form of ASC/6789.
On clicking "Add New Order" how can I get Textbox4 to look at the last Order No and add 1, i.e. automatically generate the next sequential Order No?
Your help much appreciated
I am converting a data entry spreadsheet into a Userform for ease of entry. On the spreadsheet I have to following formula, (courtesy of Yogi Anand):
=IF(A5>0,LEFT(B4,4)&RIGHT(B4,4)+1,"")
This looks at the cell above and adds 1 to the numeric part, if the cell to the left contains something (a date in this case). The cell above contains an Order No in the form of ASC/6789.
On clicking "Add New Order" how can I get Textbox4 to look at the last Order No and add 1, i.e. automatically generate the next sequential Order No?
Your help much appreciated