Can someone look at this array program tell me what I am doing wrong.
Can someone look at this array program tell me what I am doing wrong.
It would help if yo told us what was supposed to happen, and what does/does not happen.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
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.
[VBA]'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[/VBA]
Consider using a Userform with a Combobox for your Part Numbers and a Textbox for Quantities. Easier to use and looks better.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Here's a very basic Userform example
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'