Create new invoice number

RonBuss

New Member
Joined
Jan 25, 2024
Messages
5
Office Version
  1. 365
Platform
  1. Windows
I followed the tutorial videos step by step to create your own invoice program. However I substituted this to create my own purchase order program. However I want to continue from a certain number within my purchase order sequences i.e. 9034 so on. I entered this and save it just to get started. When I tap my macro for new PO it showed next PO number is 9034. However in the PO# box it showed as #1.
Please see screen shots. Any advice what I am doing wrong. Thank-you
1706214482890.png

1706214502857.png

1706214528147.png
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
My apologies. How do you post the macro. I am in module 1 looking at the steps and there is no area that says post. Could you give guidance on this.
 
Upvote 0
Copy the macro and paste it into the reply, highlight it and click the VBA thingie at the top of the reply window to wrap the selection with code tags.
 
Upvote 0
Thank-you, Found the problem. Did not proof read the macro enough and was referencing inv and not purch.
 
Upvote 0

Forum statistics

Threads
1,224,814
Messages
6,181,128
Members
453,021
Latest member
Justyna P

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top