Chris66
04-19-2006, 08:29 AM
I have a spreadsheet that schedules a part from a supplier. This spreadsheet will contain about 3 - 5K of lines a day and will support about 9 production lines. I have found a way to have excel/VBA start adding the quantities of each work order until it reaches 1,000 or slightly more.
I want to have a userform ask the user to input the workorder number they want to start with. I am hung up on how to get the macro to go find the work order # (from the user) in colum "B". My user form has a text box which I call SR. Can someone please help me? I have come so far on this project but am very inexperience with VBA. I am pulling my hair out.
For example, I would want the user form to promt the user to enter the starting release, say 5A321-15...Excel would find Release 5A321-15 go to column "C" (the quantity column) and start adding the quantities until it reached 1,000 or so. And then hightlight the range that were included in the calculation. so if 5A321-15 was in B15 excel would add up C15...C23 and highlight A15 though E15. I hope I am clear in what I am seeking.
I want to have a userform ask the user to input the workorder number they want to start with. I am hung up on how to get the macro to go find the work order # (from the user) in colum "B". My user form has a text box which I call SR. Can someone please help me? I have come so far on this project but am very inexperience with VBA. I am pulling my hair out.
For example, I would want the user form to promt the user to enter the starting release, say 5A321-15...Excel would find Release 5A321-15 go to column "C" (the quantity column) and start adding the quantities until it reached 1,000 or so. And then hightlight the range that were included in the calculation. so if 5A321-15 was in B15 excel would add up C15...C23 and highlight A15 though E15. I hope I am clear in what I am seeking.