I would ask the user for 11 items in one inputbox separated by commas, or
something reasonable (depending on the regional settings for example), and
then use the Split() function to create an array of those 11 items, which
you can pass directly to the worksheet after that.

--
Regards,

Juan Pablo González

"adamstn2 " wrote in message
...
hi all,
i am working on a semster project for a class where i have to write a
program. this is what i want my program to do i want to ask a user to
enter in 11 x values and 11 y values evenly spaced. then i my program
to make a graph of the inputted values. and finally i want to give the
user the option of how they want to find the area under the curve by
using simpons rule, the trapezodial rule, midpoint rule, and reimanns
sum.

my problem is that i want to take the 11 x and y values that the user
entered in and display them in an excel worksheet. i thought i could
put the entered values into an array and then display that array in an
excel worksheet but i am running into problems. also i am using a for
loop to ask the user 11 times to enter an x value and i am using a
seperate for loop to ask the user 11 times to enter a y value. these
are the numbers that i am trying to get into a array and displayed into
an excel worksheet.

if anyone can help me or give me some helpful tips please do so.

thank you
adamstn2


---
Message posted from http://www.ExcelForum.com/