how to enter data into cells through vba forms

[zigzag]

I have this worksheet that has two columns, one labelled Month and the other labelled Number. I also have a form that allow me to enter the data into the worksheets under the two columns by clicking a button called "add". But what I want to do now is by clicking on another button called "End" I will be able to enter 3 rows under the data I've inserted into the worksheets with the name "min", "max" and "aver", this is what I have:

Please Login or Register  to view this content.

however this code only inserts the "Aver" under the data, but the Min and Max is no where to be found.

[abousetta]

You are writing all three values in the cell Cells(jRow, 1)

Maybe try this:

Please Login or Register  to view this content.

abousetta

[zigzag]

You are writing all three values in the cell Cells(jRow, 1)

Maybe try this:

Please Login or Register  to view this content.

abousetta

Thanks that worked well! I have one more question, what I want to do now is calculate the minimum, maximum and average for the Number column(column B), I need to calculate them by using the data I entered through the forms, the problem is there's no fix amount of numbers that the user will enter so I can't determine a fixed range eg average of B2:B9, so is there a way that I could find the min, max and average of the numbers the user entered via the form into the cells? So I'll have something like this:

Please Login or Register  to view this content.

[zigzag]

Update: I managed to figure out how to do the Min and Max, now trying on Average.

[abousetta]

Off the top of my head, I would try:

Please Login or Register  to view this content.

This should put a formulas in each cell for Min, Max and Aver, but they will be volatile (in other words they will update each time you add new data.

If you want it to only calculate at the moment of submission and leave only the value then you might want something like:

Please Login or Register  to view this content.

abousetta