View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Archie Hernandez Archie Hernandez is offline
external usenet poster
 
Posts: 4
Default 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 ***