Select one checkbox to Add a Purchase Order (PO) Number

[Archie Hernandez]

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 ***

 

[corey]

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]

Hi Corey,

Thanks for responding! This is correct. How would I create this macro?

Best.




*** Sent via Developersdex http://www.developersdex.com ***