LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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 ***
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setup Purchase Order Template to have a automatic number system? LynnB Excel Worksheet Functions 2 July 19th 06 03:08 AM
Increment Purchase Order Number Curious Excel Programming 2 June 15th 06 02:37 PM
Purchase order... Bossgobbler Excel Worksheet Functions 3 May 19th 06 10:02 PM
purchase order counter in excel purchase order template Brandy@baoco Excel Worksheet Functions 0 February 23rd 05 06:17 PM
I want a purchase order that includes page number (if to be order. Angela New Users to Excel 1 December 3rd 04 04:39 PM


All times are GMT +1. The time now is 09:30 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"