Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select one checkbox to Add a Purchase Order (PO) Number
Help with Excel and VB!
Every week, I am given a new purchase order (PO) number from my accounting department which I must reference when doing my orders. (e.g. PO # 200, 300, 400, 500, 600, etc.) If I'm given a PO number, then I am expected to use that number as my starting point. (e.g. Told to use PO Number 200, thus Order 1 = 200, Order 2 = 201, Order 3 = 202, etc.) I have 12 orders I have to do for work on a weekly basis. Sometimes, I am doing all 12 orders, and other times I am doing only 3 or 5 orders. Thus, to reduce confusion, I have created an easy order sheet with checkboxes next to the Order Company. What I would like to do is assign a cell (like cell E1) with the starting PO number that I am given, and then when I click on a checkbox for an order, that PO number will appear at another assigned cell. Subsequently, if I check another checkbox, then I would like another cell to give me the following/next value. Does anyone have any suggestions or VB scripts that might help. I'm not that good at VB. Thanks! *** Sent via Developersdex http://www.developersdex.com *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select one checkbox to Add a Purchase Order (PO) Number
If i understand correctly you want to click the checkbox to generate the
P/o. Then each time a new P/o from sqame company is required the next P/o is generated to a cell? If so, i think you would be best to scrap the checkbox and use a commandbutton. Create a macro to request input of the original company P/o number, then it places it to a cell. If further P/o are required for the same company, then the next P/o's are generated and placed in the cell required. Is that what you were intending? Corey.... "Archie Hernandez" wrote in message ... Help with Excel and VB! Every week, I am given a new purchase order (PO) number from my accounting department which I must reference when doing my orders. (e.g. PO # 200, 300, 400, 500, 600, etc.) If I'm given a PO number, then I am expected to use that number as my starting point. (e.g. Told to use PO Number 200, thus Order 1 = 200, Order 2 = 201, Order 3 = 202, etc.) I have 12 orders I have to do for work on a weekly basis. Sometimes, I am doing all 12 orders, and other times I am doing only 3 or 5 orders. Thus, to reduce confusion, I have created an easy order sheet with checkboxes next to the Order Company. What I would like to do is assign a cell (like cell E1) with the starting PO number that I am given, and then when I click on a checkbox for an order, that PO number will appear at another assigned cell. Subsequently, if I check another checkbox, then I would like another cell to give me the following/next value. Does anyone have any suggestions or VB scripts that might help. I'm not that good at VB. Thanks! *** Sent via Developersdex http://www.developersdex.com *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select one checkbox to Add a Purchase Order (PO) Number
Hi Corey,
Thanks for responding! This is correct. How would I create this macro? Best. *** Sent via Developersdex http://www.developersdex.com *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setup Purchase Order Template to have a automatic number system? | Excel Worksheet Functions | |||
Increment Purchase Order Number | Excel Programming | |||
Purchase order... | Excel Worksheet Functions | |||
purchase order counter in excel purchase order template | Excel Worksheet Functions | |||
I want a purchase order that includes page number (if to be order. | New Users to Excel |