Writing to Excel

[RobDog888]

I dont quite follow how you need it to be. Could you give an example?

[samtaylor08]

Right I have 2 listboxes, on for product and one for the price of the product.

So What I want is to list the contents of the listboxes into a cell.

So for example I will write to A1 with how I want it:
Product 1, Price 1
Product 2 , Price 2
Product 3, Price 3
and so on till all of the items are listed in that cell.

But what happens now is the last product and the last price are the only ones listed, because they overwrite the rest.

Its quite hard to explain, hope this helps you a little more to understand what I want.

Thanks

Sam