I would like to have a user enter values in a form and have the form display
calculated value (based on some of those entries) after a button click, then
add all the values (included the calculated one) into a spreadsheet.

How can I do this?

Thanks.

Hi Bill,

See Debra Dalgleish's tutorials at:

http://www.contextures.com/xlUserForm01.html

and

http://www.contextures.com/xlUserForm02.html


---
Regards,
Norman



"Bill" wrote in message
...
I would like to have a user enter values in a form and have the form
display
calculated value (based on some of those entries) after a button click,
then
add all the values (included the calculated one) into a spreadsheet.

How can I do this?

Thanks.

What do you mean by form - A Userform


Private Sub CommandButton1_Click()
Dim i as Long, s as String
Dim sum as Double
for i = 1 to 5
s = Userform1.Controls("TextBox" & i).Value
if isnumeric(s) then
sum = sum + cdbl(s)
end if
Next i
Userform1.Textbox8.Value = Format(sum,"#,##0.00")
Worksheets("Sheet2).Range("B9").Value = sum
End Sub

--
Regards,
Tom Ogilvy


"Bill" wrote in message
...
I would like to have a user enter values in a form and have the form
display
calculated value (based on some of those entries) after a button click,
then
add all the values (included the calculated one) into a spreadsheet.

How can I do this?

Thanks.