excel vba array problem

A

adamstn2

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

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

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

thank you
adamstn
 
J

Juan Pablo Gonzalez

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.
 
Top