PDA

View Full Version : Array help



buddy2000
03-21-2011, 11:26 AM
Can someone look at this array program tell me what I am doing wrong.

Bob Phillips
03-21-2011, 02:32 PM
It would help if yo told us what was supposed to happen, and what does/does not happen.

buddy2000
03-21-2011, 02:46 PM
It is supppose to look up the part numbers on one sheet and the fill in the other sheet. ie if you buy 25 products of one thing then it will fill in the total the discount and so on.

mdmackillop
03-21-2011, 03:11 PM
'Count the number of parts and redim the arrays
With Sheets("Sheet 3").Range("A1")
'and
'Display information on sales sheet
Worksheets("Sheet 2").Range("B1").Value = Requestedcode

Consider using a Userform with a Combobox for your Part Numbers and a Textbox for Quantities. Easier to use and looks better.

mdmackillop
03-21-2011, 03:32 PM
Here's a very basic Userform example