I would like to be able to have the user enter an undetermined number of
scores in a user form and then calculate the total (multiple scores for
multiple games and multiple teams all unknown), show the results TOTAL and
have the user click okay or fix any input errors. It would be nice if they
could enter all scores at once and then show a 'pretty' table. I've gotten
to where I can get a fixed number of scores going but when it goes outside
the parameter I'm stuck. The user will probably not know at the start how
many scores they will be entering. Help.

Why not just have a form with a single score, and have OK, Quit, and More
buttons. More would save as does OK, but would clear the form and
re-display.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rominall" wrote in message
...
I would like to be able to have the user enter an undetermined number of
scores in a user form and then calculate the total (multiple scores for
multiple games and multiple teams all unknown), show the results TOTAL and
have the user click okay or fix any input errors. It would be nice if
they
could enter all scores at once and then show a 'pretty' table. I've
gotten
to where I can get a fixed number of scores going but when it goes outside
the parameter I'm stuck. The user will probably not know at the start how
many scores they will be entering. Help.

Okay, so I'm one of those people who knows enough to be dangerous. How do I
set up the variable declaration?

"Bob Phillips" wrote:

Why not just have a form with a single score, and have OK, Quit, and More
buttons. More would save as does OK, but would clear the form and
re-display.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rominall" wrote in message
...
I would like to be able to have the user enter an undetermined number of
scores in a user form and then calculate the total (multiple scores for
multiple games and multiple teams all unknown), show the results TOTAL and
have the user click okay or fix any input errors. It would be nice if
they
could enter all scores at once and then show a 'pretty' table. I've
gotten
to where I can get a fixed number of scores going but when it goes outside
the parameter I'm stuck. The user will probably not know at the start how
many scores they will be entering. Help.

I'm not clear as to which variable you mean.

What are you comfortable with, what do you need help with?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rominall" wrote in message
...
Okay, so I'm one of those people who knows enough to be dangerous. How do
I
set up the variable declaration?

"Bob Phillips" wrote:

Why not just have a form with a single score, and have OK, Quit, and
More
buttons. More would save as does OK, but would clear the form and
re-display.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rominall" wrote in message
...
I would like to be able to have the user enter an undetermined number
of
scores in a user form and then calculate the total (multiple scores
for
multiple games and multiple teams all unknown), show the results TOTAL
and
have the user click okay or fix any input errors. It would be nice if
they
could enter all scores at once and then show a 'pretty' table. I've
gotten
to where I can get a fixed number of scores going but when it goes
outside
the parameter I'm stuck. The user will probably not know at the start
how
many scores they will be entering. Help.

Since there will be an undertermined "more" how do I keep track of the user
input? If I make the user input an array, how do I set the array
Scores(x) = Textbox.text
Scores = Array(1 to x)???

If I treat it as a variable
Scores = textbox.text
If it resets the user form, how can I keep track the old score?

In the end I want to display the scores something like this as a list box.

1100
500
-250
100
20
Total 1470
This is so they can look and see if they made any typos click on the typo
and re-enter. I don't want to keep the individual scores after they exit the
user form but I will be storing the total.

Or should this be handled in the user form declaration (generate a variable
number of user forms)? If this is the answer, how do I do that? They
currently enter this user form by a click event on another user form which I
want to go back to once they click "Score" which will put the total on the
worksheet.

I'm not a coder, never really taken any classes on coding so this might be
elementary programming stuff. It seems like there's a big gap in my
understanding of how to handle this.

"Bob Phillips" wrote:

I'm not clear as to which variable you mean.

What are you comfortable with, what do you need help with?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rominall" wrote in message
...
Okay, so I'm one of those people who knows enough to be dangerous. How do
I
set up the variable declaration?

"Bob Phillips" wrote:

Why not just have a form with a single score, and have OK, Quit, and
More
buttons. More would save as does OK, but would clear the form and
re-display.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Rominall" wrote in message
...
I would like to be able to have the user enter an undetermined number
of
scores in a user form and then calculate the total (multiple scores
for
multiple games and multiple teams all unknown), show the results TOTAL
and
have the user click okay or fix any input errors. It would be nice if
they
could enter all scores at once and then show a 'pretty' table. I've
gotten
to where I can get a fixed number of scores going but when it goes
outside
the parameter I'm stuck. The user will probably not know at the start
how
many scores they will be entering. Help.