Thread: How to get a calculated value on a userform
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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


Reply With QuoteReply With Quote