Quotes, Picklists, Parts Database

Hi,

Im very new to VBA and come to a dead end with my program so need a helping hand. What I am trying to do is:

1. Create a list of parts divided into sections to suit each part.
2. Select each part number using a Checkbox which enables a text box (for quantity)
3. When I type in my quantity I want to press enter key and the data to be copied to another worksheet in the same book.
4. I also have prices and other information on another sheet which I would like to copy along with the above, but can we get the above sorted and move on from that?

Many Thanks
Scott McQ

Hi,

Thanks for the speedy reply. I have attached the document now and will go through what I have done so far..

1. Created Parts List Sheet
2. Created Part Prices Sheet
3. Created Rep Prices Sheet
4. Created Produced Pick List Sheet
5. On the Parts list I have a list of part numbers which have individual checkboxes and textboxes. When I check a parts checkbox the text box for this part is enabled. I can then put in the quantity of this part that I want. If I uncheck the checkbox the textbox will clear and do nothing.
6. Uploaded dummy prices to part prices list.
7. Formula created to add percentage on for reps prices sheet.

(All of the above is how I want the program to work.. I just need help with the following to get me back on track..

When I check say checkbox1, textbox1 is enabled. What I want to do from here is, when the checkbox is checked, copy - whatever I type into textbox1, the part number/name (text in a cell) and the description of item (table title). Obviously If I uncheck the checkbox then the above does not copy and nothing happens.

All this information would need to be pasted onto the produced pick list sheet. If it is at all possible in the order as the excel document shows and for each item added then go to the next row.. Hope all this makes sence..

And thanks again..