| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot table, IF function, calculated item versus calculated field | Excel Discussion (Misc queries) | |||
| I want to create a calculated item based on a calculated field | Excel Discussion (Misc queries) | |||
| Calculated Field and Calculated Item in Pivot Table | Excel Discussion (Misc queries) | |||
| PivotTable:Using a calculated field result in another calculated f | Excel Worksheet Functions | |||
| pivot table formulas for calculated field or calculated item | Excel Discussion (Misc queries) | |||
Linear Mode
