How to get a calculated value on a userform
 

Hi,

I would like to get calculated values on a "summary" userform
Any ideas ?
thanks,
Jean-Pierre


--
Message posted via http://www.officekb.com

How to get a calculated value on a userform
 

With Userform1()
.Textbox1.Text = Application.Sum(Worksheets("Detail").Range("A1:A50 "))
.Show
End With

--
Regards,
Tom Ogilvy


"Jean-Pierre D via OfficeKB.com" wrote in message
...
Hi,

I would like to get calculated values on a "summary" userform
Any ideas ?
thanks,
Jean-Pierre


--
Message posted via http://www.officekb.com

How to get a calculated value on a userform
 

Hi Tom,

Thanks, this helps me a lot !

But here's yet another question that comes up....

Is having the calculated field appear on a page of the multipage userform the
right way to display information to the user or is there a better way ?

Tom Ogilvy wrote:
With Userform1()
.Textbox1.Text = Application.Sum(Worksheets("Detail").Range("A1:A50 "))
.Show
End With

Hi,

I would like to get calculated values on a "summary" userform
Any ideas ?
thanks,
Jean-Pierre


--
Message posted via http://www.officekb.com

How to get a calculated value on a userform
 

that would really depend on your specific situation. Summarizing data can
be done easily on a pivot table on a worksheet, but that may not be
applicable to what you are doing.

--
Regards,
Tom Ogilvy

"Jean-Pierre D via OfficeKB.com" wrote in message
...
Hi Tom,

Thanks, this helps me a lot !

But here's yet another question that comes up....

Is having the calculated field appear on a page of the multipage userform
the
right way to display information to the user or is there a better way ?

Tom Ogilvy wrote:
With Userform1()
.Textbox1.Text = Application.Sum(Worksheets("Detail").Range("A1:A50 "))
.Show
End With

Hi,

I would like to get calculated values on a "summary" userform
Any ideas ?
thanks,
Jean-Pierre


--
Message posted via http://www.officekb.com